August 21, 2008 at 9:18 am
I am running sql200 been working for several years. Yesterday network connectivity was lost. sql apps all work locally but not over the network. I am able to log onto the machine over the net but not the sql server. Cannot find the sql server with enterprize mngr over the net but ok local. Also sql agent fails to launch error says unable to logon to sql server.
Any clue would be appreciated greatly.
August 21, 2008 at 12:36 pm
There are numerous possible causes for this issue, you need to start eliminating specific items. Here are some things to check.
Check that all services are running.
Check event logs for application and system on the server and make sure no messages.
Verify that TCP/IP Protocol is enabled on the server.
Check windows firewall.
Can you connect to the sql port from a client machine? Try to ping the server. If it responds try to telnet to the IP address on 1433 (if you are using the default port) and see if it connects.
Can the server see any of the clients or other machines?
Let me knwo the results and I cna maybe help further.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply