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 ?
regards
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
>
|||Mike Epprecht (SQL MVP) wrote:
[vbcol=seagreen]
> 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 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:
>
> 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:
>
> 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:
>
> 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:
[vbcol=seagreen]
> 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:
>
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?