I can't Start\Stop\Pause SQL Server or SQL Agent from Remote SSMS

13 Apr 2007 7:22 PM

jrunowski

Hello,
I do all of my SQL Server administration remotely from my workstation and
i noticed that the green running status symbol was blank on one of my MS SQL
2005 servers. I also noticed that when i right click on the server name my
options for start stop and pause are disabled. I can see all of the tables
and run my queries without any issues. If i log onto the server itself i can
see the status symbols and start\stop\pause the services for the Server and
Agent. Does anyone know why i wouldnt be able to remotely do this or see the
status of the server services? Thanks in advance for the help!

14 Apr 2007 10:04 PM

Erland Sommarskog

jrunowski (jrunow***@discussions.microsoft.com) writes:

> I do all of my SQL Server administration remotely from my workstation
> and i noticed that the green running status symbol was blank on one of
> my MS SQL 2005 servers. I also noticed that when i right click on the
> server name my options for start stop and pause are disabled. I can see
> all of the tables and run my queries without any issues. If i log onto
> the server itself i can see the status symbols and start\stop\pause the
> services for the Server and Agent. Does anyone know why i wouldnt be
> able to remotely do this or see the status of the server services?

Normally, you can only stop and start services on the local machine. This
is not specific to SQL Server, but applies to Windows in general. I guess
that you can configure a machine so that services can be stopped and
started from a remote computer, but it sonds like a dare security-wise.

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx