x

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,
more ▼

asked Aug 11, 2011 at 02:27 AM in Default

pits gravatar image

pits
830 83 91 92

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
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.
more ▼

answered Aug 11, 2011 at 02:38 AM

WilliamD gravatar image

WilliamD
25.9k 17 19 41

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.
Aug 11, 2011 at 03:09 AM pits
Sorry, but if other people can ping the server and you can't, then there must be a problem at your end.
Aug 11, 2011 at 03:22 AM WilliamD

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?
Aug 11, 2011 at 03:26 AM pits

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.
Aug 11, 2011 at 03:37 AM WilliamD
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x92
x27
x17
x2

asked: Aug 11, 2011 at 02:27 AM

Seen: 753 times

Last Updated: Sep 02 at 07:25 AM