Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    55

    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?

    Thanks in advance.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    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.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Mar 2004
    Posts
    55

    Re

    Thanks much

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •