question

pits avatar image
pits asked

SQL Agent query and connectivity problem

Hello, I am failing to connect to sql 2000 standard edition server. I tried to ping the same server but noticed requested timed out however the other users from various other locations are able to ping the same server. Not sure why I am not able to ping the same server from my end. I do not have any latency issue at my end. Also is there any command to check if Agent is up on this server from command prompt from my client machine? Do I need to think about DAC? How can I do that? rgds,
sql-agentnetworkservicesping
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
WilliamD avatar image
WilliamD answered
If your server is not ping-able from your machine but is from other machines, I would think you are having network problems at your end. Speak with your network admins and get them to take a look. Maybe there is some other problem (infrastructure) problem preventing you from reaching the server.
4 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Quote (with my emphasis): "I tried to ping the same server but noticed ***requested timed out*** however the ***other users from verious other locations are able to ping the same server***. ***Not sure why I am not able to ping the same server from my end***.I do not have any latency issue at my end." If the server is not reachable via ping, you cannot check the status of anything on that server from your machine. You need to connect to the server somehow to check if the service is running. Once you have sorted out your connection problems, you can check if the service is running using WMI or Powershell.
3 Likes 3 ·
thanks William, There is no network issue since I am able to access other servers,also confirmed form network team that there is no network issue at our end.
0 Likes 0 ·
Sorry, but if other people can ping the server and you can't, then there must be a problem at your end.
0 Likes 0 ·
Thanks William, is there any command to check if Agent is up on this server from command prompt from my client machine? Do I need to think for DAC? how can I do that?
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.