November 26, 2009 at 8:34 am
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!
November 26, 2009 at 8:37 am
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?
November 26, 2009 at 8:42 am
I've tried to disconnect and connect object explore and restart the SSMS several times already, nothing works.
Bazinga!
November 26, 2009 at 8:55 am
xnleiden (11/26/2009)
Hello everyoneI 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.
November 26, 2009 at 10:22 am
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
November 26, 2009 at 11:30 am
SQL Server Browser service is running.
Bazinga!
November 26, 2009 at 11:32 am
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!
November 26, 2009 at 12:03 pm
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.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 26, 2009 at 12:04 pm
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!
November 26, 2009 at 12:15 pm
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.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 26, 2009 at 12:51 pm
'sa' is used for sql authentication. I assume this should have the highest privilege of all.
Bazinga!
November 26, 2009 at 9:31 pm
This issue frequently occurs if you do not have administrative permissions to stop, start, or restart services.
Verify that you have adequate permissions to start services on the server where sql is installed.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 27, 2009 at 2:44 am
I really don't want this thread sink in vain like all others that I can find from Google.
I used the 'sa' account and SQL Server authentication to connection from my workstation to the server and I believe 'sa' has sufficient privilege to start, stop or restart the SQL Server service.
I also tried remote desktop the server directly, log on to SSMS by 'sa' again and the green arrow appears fine.
Bazinga!
November 27, 2009 at 2:47 am
xnleiden (11/27/2009)
I really don't want this thread sink in vain like all others that I can find from Google.I used the 'sa' account and SQL Server authentication to connection from my workstation to the server and I believe 'sa' has sufficient privilege to start, stop or restart the SQL Server service.
I also tried remote desktop the server directly, log on to SSMS by 'sa' again and the green arrow appears fine.
Its got nothing to do with being able to start/stop the services, its all to do with if your windows account has access to see the services state. go to start, run and type services.msc, change the machine name to the server your connecting to in ssms and see if you can see the sql services, i bet you wont be able too.
November 27, 2009 at 3:18 am
Hello Animal Magic
I did try services.msc and connect it to the server and all start, stop and restart options are there for MSSQLSERVER service.
And the windows account I used for log on to my local workstation is a domain admin FYI.
Could you please advise me a bit more? Thanks.
Animal Magic (11/27/2009)
xnleiden (11/27/2009)
I really don't want this thread sink in vain like all others that I can find from Google.I used the 'sa' account and SQL Server authentication to connection from my workstation to the server and I believe 'sa' has sufficient privilege to start, stop or restart the SQL Server service.
I also tried remote desktop the server directly, log on to SSMS by 'sa' again and the green arrow appears fine.
Its got nothing to do with being able to start/stop the services, its all to do with if your windows account has access to see the services state. go to start, run and type services.msc, change the machine name to the server your connecting to in ssms and see if you can see the sql services, i bet you wont be able too.
Bazinga!
Viewing 15 posts - 1 through 15 (of 94 total)
You must be logged in to reply to this topic. Login to reply