connection error after 15 minutes of restart

I have a problem with ms sql 2000 installed on windows 2000 server.
Sql has sp3 or sp3a installed - I am not sure if sp3a was installed
Last night security update pack for IE 6 with SP1 was installed on the
server (KB867801)
Since morning sql server is working for 15 minutes, then connection is
not available - I got connection error message: msg: 17, level 16, state
1, SQL Server does not exists or access denied
After restarting SQL Server all works fine for about 15 minutes.
any clue ?
regardsMike Epprecht (SQL MVP) wrote:
> Have you checked the SQL event log for errors?
> Using Query Analyzer, run sp_who or sp_who2 when the error occurs and check
> the number of connections.
> Regards
> Mike
>
> "yooyoo" wrote:
>
>>I have a problem with ms sql 2000 installed on windows 2000 server.
>>Sql has sp3 or sp3a installed - I am not sure if sp3a was installed
>>Last night security update pack for IE 6 with SP1 was installed on the
>>server (KB867801)
>>Since morning sql server is working for 15 minutes, then connection is
>>not available - I got connection error message: msg: 17, level 16, state
>>1, SQL Server does not exists or access denied
>>After restarting SQL Server all works fine for about 15 minutes.
>>any clue ?
>>regards
I will do it in some 10 minutes - I restarted server 5 minutes ago.
In SQL Log I have errors:
server SuperSocket Info: Bind failed on TCP port 1433.
server Error: 17882, Severity: 18, State: 1
server Error accepting connection request via Net-Library 'SSNETLIB'.
Execution continuing...
server Error: 17059, Severity: 18, State: 0
server Operating system error 0: The operation completed successfully...|||yooyoo wrote:
> Mike Epprecht (SQL MVP) wrote:
>> Have you checked the SQL event log for errors?
>> Using Query Analyzer, run sp_who or sp_who2 when the error occurs and
>> check the number of connections.
>> Regards
>> Mike
>>
>> "yooyoo" wrote:
>>
>> I have a problem with ms sql 2000 installed on windows 2000 server.
>> Sql has sp3 or sp3a installed - I am not sure if sp3a was installed
>> Last night security update pack for IE 6 with SP1 was installed on
>> the server (KB867801)
>> Since morning sql server is working for 15 minutes, then connection
>> is not available - I got connection error message: msg: 17, level 16,
>> state 1, SQL Server does not exists or access denied
>> After restarting SQL Server all works fine for about 15 minutes.
>> any clue ?
>> regards
> I will do it in some 10 minutes - I restarted server 5 minutes ago.
> In SQL Log I have errors:
> server SuperSocket Info: Bind failed on TCP port 1433.
> server Error: 17882, Severity: 18, State: 1
> server Error accepting connection request via Net-Library 'SSNETLIB'.
> Execution continuing...
> server Error: 17059, Severity: 18, State: 0
> server Operating system error 0: The operation completed successfully...
sp_who returned 31 rows|||yooyoo wrote:
> yooyoo wrote:
>> Mike Epprecht (SQL MVP) wrote:
>> Have you checked the SQL event log for errors?
>> Using Query Analyzer, run sp_who or sp_who2 when the error occurs and
>> check the number of connections.
>> Regards
>> Mike
>>
>> "yooyoo" wrote:
>>
>> I have a problem with ms sql 2000 installed on windows 2000 server.
>> Sql has sp3 or sp3a installed - I am not sure if sp3a was installed
>> Last night security update pack for IE 6 with SP1 was installed on
>> the server (KB867801)
>> Since morning sql server is working for 15 minutes, then connection
>> is not available - I got connection error message: msg: 17, level
>> 16, state 1, SQL Server does not exists or access denied
>> After restarting SQL Server all works fine for about 15 minutes.
>> any clue ?
>> regards
>>
>> I will do it in some 10 minutes - I restarted server 5 minutes ago.
>> In SQL Log I have errors:
>> server SuperSocket Info: Bind failed on TCP port 1433.
>> server Error: 17882, Severity: 18, State: 1
>> server Error accepting connection request via Net-Library 'SSNETLIB'.
>> Execution continuing...
>> server Error: 17059, Severity: 18, State: 0
>> server Operating system error 0: The operation completed successfully...
>
> sp_who returned 31 rows
The problem was another instance running on the server. But why it all
worked ok untill IE pack ?
regards,|||yooyoo wrote:
> yooyoo wrote:
>> yooyoo wrote:
>> Mike Epprecht (SQL MVP) wrote:
>> Have you checked the SQL event log for errors?
>> Using Query Analyzer, run sp_who or sp_who2 when the error occurs
>> and check the number of connections.
>> Regards
>> Mike
>>
>> "yooyoo" wrote:
>>
>> I have a problem with ms sql 2000 installed on windows 2000 server.
>> Sql has sp3 or sp3a installed - I am not sure if sp3a was installed
>> Last night security update pack for IE 6 with SP1 was installed on
>> the server (KB867801)
>> Since morning sql server is working for 15 minutes, then connection
>> is not available - I got connection error message: msg: 17, level
>> 16, state 1, SQL Server does not exists or access denied
>> After restarting SQL Server all works fine for about 15 minutes.
>> any clue ?
>> regards
>>
>> I will do it in some 10 minutes - I restarted server 5 minutes ago.
>> In SQL Log I have errors:
>> server SuperSocket Info: Bind failed on TCP port 1433.
>> server Error: 17882, Severity: 18, State: 1
>> server Error accepting connection request via Net-Library 'SSNETLIB'.
>> Execution continuing...
>> server Error: 17059, Severity: 18, State: 0
>> server Operating system error 0: The operation completed successfully...
>>
>> sp_who returned 31 rows
>
> The problem was another instance running on the server. But why it all
> worked ok untill IE pack ?
> regards,
>
I was too much optimistic. The nightmare started again at 8 a.m. :-(
I try to change port to somethign alse than 1433.
Hope reistall will help
regards|||Mike Epprecht (SQL MVP) wrote:
> Have you checked the SQL event log for errors?
> Using Query Analyzer, run sp_who or sp_who2 when the error occurs and check
> the number of connections.
> Regards
> Mike
>
> "yooyoo" wrote:
>
>>I have a problem with ms sql 2000 installed on windows 2000 server.
>>Sql has sp3 or sp3a installed - I am not sure if sp3a was installed
>>Last night security update pack for IE 6 with SP1 was installed on the
>>server (KB867801)
>>Since morning sql server is working for 15 minutes, then connection is
>>not available - I got connection error message: msg: 17, level 16, state
>>1, SQL Server does not exists or access denied
>>After restarting SQL Server all works fine for about 15 minutes.
>>any clue ?
>>regards
sp_who returns just 31 rows
but there huge list on port mapping like: (10 times like this)
TCP 3095 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3096 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3097 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3098 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3099 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3100 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3101 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3102 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3103 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3104 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3105 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3106 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3107 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3108 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3109 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3110 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3111 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3112 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3113 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3114 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3115 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3116 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3117 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3118 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3119 192.168.2.2 TIME WAIT 192.168.2.2:1433
any clue?
regards|||I have the same problem, sp_who only shows < 50 connections. Any other ideas
please?