Post reply

Server and Agent Icon in Object Explorer Not Showing Status

  • January 9, 2017 at 12:21 pm

    #339255

    Hello. In SSMS object explorer, sometimes the SQL Server node and the Agent node show a blank white circle instead of the normal "play arrow" or "x" to indicate "running" and "stopped" status, respectively.

    In itself, this is not really a big deal, but I wonder if it indicates a bigger problem with our environment. I've noticed it occasionally throughout my career but never asked.

    Does anyone know what causes this to happen?

    Thanks!

  • January 9, 2017 at 1:30 pm

    #1921486

    When it is blank white circles, it is specifically telling you that you do not have permissions to start and stop the service (where the MSSQL or the SQL Agent)

    if you right click, you'll see that the selections are grayed out for Stop/Start/Pause/Resume/Restart

    when it's green or red, you DO have permissions,and could run those commands.

    i believe the permissions are whether you local admin on the remote server, not whether you are a sysadmin in SQL

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • January 9, 2017 at 1:39 pm

    #1921488

    version and clustering may have something to do with it as well. I notice if I connect to a clustered SQL Server 2014 database with SSMS 2008 R2, I see the blank white circle also. But if I connect using SSMS 2014 or 2016 I see the correct status icon in Object Explorer. I do see the proper icon in SSMS 2008 R2 connecting to a non-clustered SQL Server 2014 instance though.

  • January 9, 2017 at 1:49 pm

    #1921492

    Thanks guys. This makes total sense for my scenario.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply