"JL" <jeryl.lederman@Remove_gmail.com_This> wrote in message
news:%237nuOvjgFHA.3448@TK2MSFTNGP12.phx.gbl...
> 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.
>

"William (Bill) Vaughn" <billvaRemoveT***@nwlink.com> wrote in message
news:e7Tw8ekgFHA.2904@tk2msftngp13.phx.gbl...
> 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.
> __________________________________
>
> "JL" <jeryl.lederman@Remove_gmail.com_This> wrote in message
> news:%237nuOvjgFHA.3448@TK2MSFTNGP12.phx.gbl...
>> 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.
>>
>
>

"JL" <jlederman@REMOVE_gmail.com_THIS> wrote in message
news:uTra4pngFHA.2156@TK2MSFTNGP14.phx.gbl...
> 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.
>
> "William (Bill) Vaughn" <billvaRemoveT***@nwlink.com> wrote in message
> news:e7Tw8ekgFHA.2904@tk2msftngp13.phx.gbl...
>> 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.
>> __________________________________
>>
>> "JL" <jeryl.lederman@Remove_gmail.com_This> wrote in message
>> news:%237nuOvjgFHA.3448@TK2MSFTNGP12.phx.gbl...
>>> 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.
>>>
>>
>>
>
>

"William (Bill) Vaughn" <billvaRemoveT***@nwlink.com> wrote in message
news:%23776pSpgFHA.3436@tk2msftngp13.phx.gbl...
> 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.
> __________________________________
>
> "JL" <jlederman@REMOVE_gmail.com_THIS> wrote in message
> news:uTra4pngFHA.2156@TK2MSFTNGP14.phx.gbl...
>> 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.
>>
>> "William (Bill) Vaughn" <billvaRemoveT***@nwlink.com> wrote in message
>> news:e7Tw8ekgFHA.2904@tk2msftngp13.phx.gbl...
>>> 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.
>>> __________________________________
>>>
>>> "JL" <jeryl.lederman@Remove_gmail.com_This> wrote in message
>>> news:%237nuOvjgFHA.3448@TK2MSFTNGP12.phx.gbl...
>>>> 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.
>>>>
>>>
>>>
>>
>>
>
>