SQL Agent query and connectivity problem

Question

question

pits asked Aug 11, '11

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-agent network services ping

10 |1200

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

Answer 1 · 2011-08-11T02:38:27Z

WilliamD answered Aug 11, '11

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

10 |1200

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

WilliamD commented · Aug 11, 2011 at 03:37 AM

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 ·

pits commented · Aug 11, 2011 at 03:09 AM

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 ·

WilliamD commented · Aug 11, 2011 at 03:22 AM

Sorry, but if other people can ping the server and you can't, then there must be a problem at your end.

0 ·

pits commented · Aug 11, 2011 at 03:26 AM

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 ·

question