-
Unable to connect to SQL server after service restart
Hi
We have been having a problem with on of our servers, applications connecting to it are experiencing poor performance, even though the server is only running at a peak of 50%.
The odd thing is that after a sql service restart we couldnt connect at all on the SQL port. We were only able to re-connect after rebooting the actuall box. Is there anything that can be done about this? Its strting to look like a network related problem instead of SQL
-
Were you able to ping the server from another machine?. Also to check whether port 1433 is reachable try (in command prompt)
telnet sqlservername 1433
if the port is open you will see blank screen otherwise connection will fail.
-
Hi
The machine was reachable, it was only port 1433 that seems to have been closed. The only thing I didnt try was opening a query locally.
-
Any related OS level message in windows event log?
-
"The system failed to register network adapter with settings"
Thats in system log
"19012 :
SuperSocket Info: Bind failed on TCP port 1433."
This is in application log, nothing else seems to indicate why this happens.
This error came up after an SQL restart during its startup
Google isnt all that helpfull either strangely enough :/
-
Then should check NIC to see if it works fine, and ensure port is not used else where.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|