September 22, 2006 at 1:27 pm
Hi everyone,
Our sql server just doesn't take any connection.
Even I restart our server and sql server database, which is on the same computer, cpu drops to normal. But as soon as I try to any program, the cpu will rise to 100%. Or you will get an error message:
Description: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Invalid connection
or
Description: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.
Then the tech support told, that windows just won't drop all the connection, that's why I cannot connect to the database
So we use netstat cmd and I see more than 1000 line of this
TCP travelinsure1:3838 travelinsure1.inetu.net:ms-sql-s TIME_WAIT
TCP travelinsure1:3840 travelinsure1.inetu.net:ms-sql-s TIME_WAIT
TCP travelinsure1:3842 travelinsure1.inetu.net:ms-sql-s TIME_WAIT
TCP travelinsure1:3844 travelinsure1.inetu.net:ms-sql-s TIME_WAIT
TCP travelinsure1:3846 travelinsure1.inetu.net:ms-sql-s TIME_WAIT
TCP travelinsure1:3848 travelinsure1.inetu.net:ms-sql-s TIME_WAIT
TCP travelinsure1:3850 travelinsure1.inetu.net:ms-sql-s TIME_WAIT
TCP travelinsure1:3852 travelinsure1.inetu.net:ms-sql-s TIME_WAIT
TCP travelinsure1:3854 travelinsure1.inetu.net:ms-sql-s TIME_WAIT
Is this the problem origination? if so, how can I kill the connection immediately?
Thank you.
BEtty
September 22, 2006 at 2:18 pm
when u stop and start SQL server all the connections would have been lost or killed. How can a tech support tell u that "Old" connection still exists.
Try running:
sp_who and look for blocks(More Info on BooksOnline)
then look as sp_lock
That will be a good starting point.
Thanks
Sreejith
September 22, 2006 at 7:37 pm
<Server does not exist or access denied>
can you access the sql serve (let say from Query Analyzer)?
Also what is OS\Edition\version\SP\ security patch level(fresh or a lot missed)
same for sql server: version\edition\SP?
September 22, 2006 at 7:51 pm
No, not even from sql server analyzer, it just refuse any connection from any where. But if I get into enterprise manager, -->tool, -->sql ananlyer, the query can be run slowly.
Our system is windows 2000 server 5.00.2195 service pack 4,
sql server is 2000 with sp4 just applied one week ago.
September 22, 2006 at 7:58 pm
Hi Sireejith,
Exactly, that' what exactly I asked. I used sp_who and sp_lock,
it is quite normal, we just have several connection to production database. and in enterprise manager,-->current activity--> I don't many processes.
But when I use this command netstat I see many active connection with different port number and I cannot explain it.
Betty
September 22, 2006 at 9:24 pm
Hi everyone,
Can you give a hint. If I ran netstat and I have thousands active connection like this:
TCP travelinsure1:3838 travelinsure1.inetu.net:ms-sql-s TIME_WAIT
but travelinsure1 is our web server and our database server is on the web server too. It seems like the web server itself is trying to connect to our database server. Like infinit loop, since local address is travelinsure1 and remote address is travelinsure1.inetu.net:ms-sql-s.
Am I right, it looks like a infinite loop.
Betty
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply