<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
Missing green arrow on the sql server icon in...
69 posts, Page 1 of 7
1
2
3
4
5
»
»»
Missing green arrow on the sql server icon in object explore
Rate Topic
Display Mode
Topic Options
Author
Message
sqlnickxu
sqlnickxu
Posted Thursday, November 26, 2009 8:34 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, May 01, 2013 7:29 PM
Points: 190,
Visits: 879
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!
Post #825246
Kwisatz78
Kwisatz78
Posted Thursday, November 26, 2009 8:37 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Monday, May 13, 2013 2:43 AM
Points: 541,
Visits: 1,398
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?
Post #825248
sqlnickxu
sqlnickxu
Posted Thursday, November 26, 2009 8:42 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, May 01, 2013 7:29 PM
Points: 190,
Visits: 879
I've tried to disconnect and connect object explore and restart the SSMS several times already, nothing works.
Bazinga!
Post #825253
AlexSQLForums
AlexSQLForums
Posted Thursday, November 26, 2009 8:55 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 11:08 AM
Points: 1,225,
Visits: 1,703
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
Post #825263
Animal Magic
Animal Magic
Posted Thursday, November 26, 2009 10:22 AM
SSC Eights!
Group: General Forum Members
Last Login: Yesterday @ 4:25 PM
Points: 983,
Visits: 13,347
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
Post #825301
sqlnickxu
sqlnickxu
Posted Thursday, November 26, 2009 11:30 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, May 01, 2013 7:29 PM
Points: 190,
Visits: 879
SQL Server Browser service is running.
Bazinga!
Post #825319
sqlnickxu
sqlnickxu
Posted Thursday, November 26, 2009 11:32 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, May 01, 2013 7:29 PM
Points: 190,
Visits: 879
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!
Post #825321
Bru Medishetty
Bru Medishetty
Posted Thursday, November 26, 2009 12:02 PM
SSCommitted
Group: General Forum Members
Last Login: Monday, February 11, 2013 8:27 AM
Points: 1,735,
Visits: 1,947
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
Post #825329
sqlnickxu
sqlnickxu
Posted Thursday, November 26, 2009 12:04 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, May 01, 2013 7:29 PM
Points: 190,
Visits: 879
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!
Post #825330
Bru Medishetty
Bru Medishetty
Posted Thursday, November 26, 2009 12:15 PM
SSCommitted
Group: General Forum Members
Last Login: Monday, February 11, 2013 8:27 AM
Points: 1,735,
Visits: 1,947
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
Post #825331
« Prev Topic
|
Next Topic »
69 posts, Page 1 of 7
1
2
3
4
5
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
