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

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!
jrunowski (jrunowski@.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, esquel@.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

I can see an IIS Server but connot see as SQL Server on same PC thru ODBC. Why?

Why is it that I can see a remote server in the browser on a workstation by typing in

ftp://MY_IIS_SERVER

but I cannot see an SQL Server 7.0 database on that same remmote PC. In other words, I cannot manually set up a Data Source Name for that SQL Server.

This happens only on WIN NT 4.0 boxes.First from your workstation can you ping MY_IIS_SERVER, if so then check that you have TCP/IP enabled using the 'Client Network Utility' that comes with SQL Server.

If you can not ping MY_IIS_SERVER, can you ping the IP address, xxx.xxx.xxx. If so then again make sure TCP/IP is enabled and then do 1 of 2.

1) Add an entry in LMHOST for MY_IIS_SERVER xxx.xxx.xxx
or
2) Use SQL Server Client Network Utility and add an alias to MY_IIS_SERVER