Can't connect to SQL server after hibernating

Hi,
I currently have a development SQL server running locally on my laptop.
After my laptop comes out of hibernation, existing connections to the server
,
such as from Query Analyzer, work fine, but I can not make new connections t
o
the server. I've tried restarting the server through the SQL Server Service
Manager, but it doesn't solve the problem. The only way to be able to
re-establish a connection is to reboot; which makes developing on the laptop
difficult.
Here is the result of "select @.@.Version":
Microsoft SQL Server 2000 - 8.00.944 (Intel X86) May 19 2004 18:32:44
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)What exact errors do you get when you can't connect?
Did you check the event logs for errors?
-Sue
On Wed, 12 Oct 2005 11:21:09 -0700, Andy Rondeau <Andy
Rondeau@.discussions.microsoft.com> wrote:

>Hi,
>I currently have a development SQL server running locally on my laptop.
>After my laptop comes out of hibernation, existing connections to the serve
r,
>such as from Query Analyzer, work fine, but I can not make new connections
to
>the server. I've tried restarting the server through the SQL Server Servic
e
>Manager, but it doesn't solve the problem. The only way to be able to
>re-establish a connection is to reboot; which makes developing on the lapto
p
>difficult.
>Here is the result of "select @.@.Version":
>Microsoft SQL Server 2000 - 8.00.944 (Intel X86) May 19 2004 18:32:44
>Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
>NT 5.1 (Build 2600: Service Pack 2)|||The error message that I'm getting (from SQL Query Analyzer) is:
"Unable to connect to server [my laptop's server name]"
"Server: Msg 17, Level 16, State 1"
"[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server d
oes not
exist or access denied."
With regard to the event log, I'm assuming that you're refering to the Event
Viewer in Administrative Tools. There's nothing SQL related in there about
a
connection failure.
Again, an existing connection in SQL Query Analyzer runs fine.
"Sue Hoegemeier" wrote:

> What exact errors do you get when you can't connect?
> Did you check the event logs for errors?
> -Sue
> On Wed, 12 Oct 2005 11:21:09 -0700, Andy Rondeau <Andy
> Rondeau@.discussions.microsoft.com> wrote:
>
>|||Could be your NIC - they can switch off in hibernation mode.
Try to telnet to the listening port.
Yes...the Event viewer displays the event logs. I'd look for
network, networking component related issues, not
necessarily just SQL errors related to connection failure.
-Sue
On Mon, 17 Oct 2005 18:28:02 -0700, Andy Rondeau
<AndyRondeau@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>The error message that I'm getting (from SQL Query Analyzer) is:
>"Unable to connect to server [my laptop's server name]"
>"Server: Msg 17, Level 16, State 1"
>"[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server
does not
>exist or access denied."
>With regard to the event log, I'm assuming that you're refering to the Even
t
>Viewer in Administrative Tools. There's nothing SQL related in there about
a
>connection failure.
>Again, an existing connection in SQL Query Analyzer runs fine.
>"Sue Hoegemeier" wrote:
>|||When I telnet into the server, it connects and the connection stays open for
about a second, and then the connection breaks.
With regard to networking events in the event log, there's some generic
adaptor connected / disconnected around the time that I went into and out of
hibernation, but nothing that would indicate that the adaptor shut down.
"Sue Hoegemeier" wrote:

> Could be your NIC - they can switch off in hibernation mode.
> Try to telnet to the listening port.
> Yes...the Event viewer displays the event logs. I'd look for
> network, networking component related issues, not
> necessarily just SQL errors related to connection failure.
> -Sue
> On Mon, 17 Oct 2005 18:28:02 -0700, Andy Rondeau
> <AndyRondeau@.discussions.microsoft.com> wrote:
>
>|||They don't always come back very well once disconnected so I
would really suspect it has something to do with that.
-Sue
On Tue, 18 Oct 2005 12:20:08 -0700, Andy Rondeau
<AndyRondeau@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>When I telnet into the server, it connects and the connection stays open fo
r
>about a second, and then the connection breaks.
>With regard to networking events in the event log, there's some generic
>adaptor connected / disconnected around the time that I went into and out o
f
>hibernation, but nothing that would indicate that the adaptor shut down.
>"Sue Hoegemeier" wrote:
>|||But that doesn't solve my problem. I AM making a successful, but short,
connection in telnet after a hibernation, which means that my network adapto
r
is not the culprit.
Is there some way of restarting the SQL server so that it'll accept
connections? Could this be an issue with the client?
"Sue Hoegemeier" wrote:

> They don't always come back very well once disconnected so I
> would really suspect it has something to do with that.
> -Sue
> On Tue, 18 Oct 2005 12:20:08 -0700, Andy Rondeau
> <AndyRondeau@.discussions.microsoft.com> wrote:
>
>|||I just wouldn't use hibernate with SQL Server running. I
wouldn't trust it with SQL anyway
-Sue
On Wed, 19 Oct 2005 10:20:01 -0700, Andy Rondeau
<AndyRondeau@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>But that doesn't solve my problem. I AM making a successful, but short,
>connection in telnet after a hibernation, which means that my network adapt
or
>is not the culprit.
>Is there some way of restarting the SQL server so that it'll accept
>connections? Could this be an issue with the client?
>"Sue Hoegemeier" wrote:
>