Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Missing green arrow on the sql server icon in object explore


Missing green arrow on the sql server icon in object explore

Author
Message
sqlnickxu
sqlnickxu
SSC-Enthusiastic
SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)

Group: General Forum Members
Points: 196 Visits: 942
Hello everyone

I have tried to Google this issue for quite awhile and can't find any definitive solution. Now in my management studio on my workstation, the icon on the server instance is simply a blank white circle with no green arrow in it. I logged on as 'sa' and I can't use right-click the instance icon to select "start", "stop", "pause", "resume" or "restart" because they are all grayed out. But all the rest operations are available.

One of the explanations that I can find online is that in this situation, the management studio can't retrieve the info whether the SQL Server service is running on the server or not. But when I use remote desktop to connect to the server itself, the green arrow is well and fine in the management studio in the remote session.

So can there be any firewall settings on the server that prevent the SQL Server service running state being communicated to my workstation?

Where should I look more into then?

Thanks for your inputs in advance!

Bazinga!
Kwisatz78
Kwisatz78
SSChasing Mays
SSChasing Mays (617 reputation)SSChasing Mays (617 reputation)SSChasing Mays (617 reputation)SSChasing Mays (617 reputation)SSChasing Mays (617 reputation)SSChasing Mays (617 reputation)SSChasing Mays (617 reputation)SSChasing Mays (617 reputation)

Group: General Forum Members
Points: 617 Visits: 1821
In SSMS if you disconnect completely from the server and then put in all the connection details again do you get the same problem or do you get a different error?
sqlnickxu
sqlnickxu
SSC-Enthusiastic
SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)

Group: General Forum Members
Points: 196 Visits: 942
I've tried to disconnect and connect object explore and restart the SSMS several times already, nothing works.

Bazinga!
AlexSQLForums
AlexSQLForums
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1361 Visits: 2249
xnleiden (11/26/2009)
Hello everyone

I have tried to Google this issue for quite awhile and can't find any definitive solution. Now in my management studio on my workstation, the icon on the server instance is simply a blank white circle with no green arrow in it. I logged on as 'sa' and I can't use right-click the instance icon to select "start", "stop", "pause", "resume" or "restart" because they are all grayed out. But all the rest operations are available.

One of the explanations that I can find online is that in this situation, the management studio can't retrieve the info whether the SQL Server service is running on the server or not. But when I use remote desktop to connect to the server itself, the green arrow is well and fine in the management studio in the remote session.

So can there be any firewall settings on the server that prevent the SQL Server service running state being communicated to my workstation?

Where should I look more into then?

Thanks for your inputs in advance!


Is sql browser service running? If yes and you tried everything else then I would reinstall tools.

Alex S
Animal Magic
Animal Magic
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1064 Visits: 13728
it doesnt matter what your connection to the server is in SSMS, its all to do with whether your windows account your using has access to the services information on the server in question. I am assuming this is a remote server on a different domain/DMZ and your windows user cannot access the services to see if its actually running
sqlnickxu
sqlnickxu
SSC-Enthusiastic
SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)

Group: General Forum Members
Points: 196 Visits: 942
SQL Server Browser service is running.

Bazinga!
sqlnickxu
sqlnickxu
SSC-Enthusiastic
SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)

Group: General Forum Members
Points: 196 Visits: 942
The workstation I used to connection to the SQL Server is in the same LAN in the same domain. I actually tried both windows account and the 'sa' account, either works in the regard of having the green arrow displayed after successful connection.

Bazinga!
Bru Medishetty
Bru Medishetty
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1662 Visits: 1950
I have seen this when working with SSMS and connecting to SQL 2000 Servers mostly, with other SQL 2005 Servers it would be normal.

What is the issue you want to solve?

You want the start/ stop/ restart options to be available / enabled or the Green Icon to appear.


Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.com\LearnSQLWithBru

Twitter -- BruMedishetty
sqlnickxu
sqlnickxu
SSC-Enthusiastic
SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)SSC-Enthusiastic (196 reputation)

Group: General Forum Members
Points: 196 Visits: 942
Yes, I do want the grayed out function to be available again.

Bru Medishetty (11/26/2009)
I have seen this when working with SSMS and connecting to SQL 2000 Servers mostly, with other SQL 2005 Servers it would be normal.

What is the issue you want to solve?

You want the start/ stop/ restart options to be available / enabled or the Green Icon to appear.



Bazinga!
Bru Medishetty
Bru Medishetty
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1662 Visits: 1950
When you login from your workstation, login details you are providing (Windows or SQL), it needs to have sysadmin Server Role Permissions on that server.


Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.com\LearnSQLWithBru

Twitter -- BruMedishetty
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search