General Network Error - LocalHost

  • Thread starter Thread starter JL
  • Start date Start date
J

JL

We have a Winforms app running on XP against a local installation of MSDE.
The machine is connected to a network. When we pull the network cable out
we get General Network Error from SQL Server even though we are connected to
the SQL Server on the local machine.

We pull the network cable out to simulate a failure during an upload process
to another machine. This process does not use SQL Server and we are not
connecting to SQL Server on any other machines from this machine. We do
have other installations of SQL Server on our network but this machine never
connects to them.

Any insight would be appreciated.
 
The network might be required to authenticate SSPI connection credentials.
Are you using "localhost" or "local" to address MSDE?

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Bill:

We are using a connection string of the following format:
"User ID=xxx;Password=yyy;Database=zzz". We are not specifying local or
localhost.
 
You still need to use the Server= or Data Source= keyword in the
ConnectionString to refer to the local system.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Bill:

It actually was working without the server= but when we added
server=localhost the problem went away.

Thanks for your assistance.
 
Back
Top