Unanswered: Newbie Questions on Enterprise Manager
Running SQL Server 2000 on various servers. On my desktop when I open Enterprise Manager I notice that some of the instances show a green arrow and some show a blank circle. I imagine that might have to do with either permissions or the account that the SQL Server Service is running on. Is that correct?
I am using the sa account on these instances and they are all using mixed mode authentication.
Also, I can not stop or start a SQL Server Service from my Enterprise Manager. When I try to start the service from EM I get an 'Access Denied - Error 5 ' message.
Shouldn't I be able to stop/start these services without going to the box they are on?
The blank circle means Enterprise Manager has not determined whether the database server is running. Clicking on the circle will force EM to detect the status of the server.
If you are being denied access, it is because your Windows account does not have a logon on that server.
If it's not practically useful, then it's practically useless.