Green Icon

  • What does the red zigzag on green icon on sql server indicates

  • It means your connected to the server in question.

    Far away is close at hand in the images of elsewhere.
    Anon.

  • If red zigzag indicates u are connected,then what does green arrow indictaes.

    Green arrow indicates that the server started sucessfully

  • The green arrow means the SERVICE is started (MSSQLSERVER service or SQLSERVERAGENT service).

    The red line means you are connected.

    You can't connect without the service being started, but you can have the service running and not be connected.

    -SQLBill

  • It also means you are using the SQL 7 Enterprise Manager. Bills answer is correct.

    However they got so many complaing that it was confusing as they thought red ZigZag meant down or some other issue that MS changed it in 2000.

    SQL 7 EM

    Empty white circle = Server state unknown.

    White circle with red square = Server is offline.

    White circle with Green play button style arrow = Server is running

    White circle with Green play button style arrow and red zigzag = Connected to server.

    SQL 2000 EM

    Empty white circle = Server state unknown.

    White circle with red square = Server is offline.

    White circle with Green play button style arrow = Server is running

    Green circle with white play button style arrow = Connected to server.

  • White circle is normally caused (if the server exists) by you not having permissions to query the state of the service on the machine (i.e different domains)

    Simon Sabin

    Co-author of SQL Server 2000 XML Distilled

    http://www.amazon.co.uk/exec/obidos/ASIN/1904347088


    Simon Sabin
    SQL Server MVP

    http://sqlblogcasts.com/blogs/simons

Viewing 6 posts - 1 through 5 (of 5 total)

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