Re: Can't connect to SQL server after hibernating

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@xxxxxxxxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>>
>> >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 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@xxxxxxxxxxxxxxxxxxxxxxxxx> 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 server,
>> >> >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 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)
>> >>
>> >>
>>
>>

.

Relevant Pages

  • Re: Web Server Cant Connect to Sql Server
    ... ok I just noticed an event on the server (hosting SQL) event log when ... Server account in the connection string in the ASP.NET page. ...
    (comp.databases.ms-sqlserver)
  • [UNIX] mmmail POP3-SMTP Daemon Format String Vulnerability
    ... There is a format string vulnerability in the 'mmsyslog' function of the ... string that can be defined by a remote user. ... test:~$ telnet test.lab.intexxia.com 110 ... Connection closed by foreign host. ...
    (Securiteam)
  • Re: Sharing Internet access with a XP box.
    ... > connects to the Internet via a dial-up ISDN connection. ... > run a telnet client on the XP machine and connect to it from the BSD ... supported on FreeBSD and you have to jump through a couple of hoops to ... or, more generically, a server. ...
    (freebsd-newbies)
  • [CERT-intexxia] mmmail POP3-SMTP Daemon Format String Vulnerability
    ... mmmail POP3-SMTP Daemon Format String Vulnerability ... Successful exploitation of this flaw can allow a remote user to obtain ... test:~$ telnet test.lab.intexxia.com 110 ... Connection closed by foreign host. ...
    (Bugtraq)
  • Re: 45 days STUCK LIKE CHUCK. DNS / Mx record cant recieve emails
    ... I don't think it's Exchange since it's responding to telnet from the LAN. ... think it's the firewall, in which case it should be fixed if you run the ... still could be the Comcast router that's blocking the incoming connection. ... like Exchange not listening on the Internet NIC. ...
    (microsoft.public.windows.server.sbs)
Quantcast