We help IT Professionals succeed at work.

cannot stop or start SQLserver from SSMS

SiemensSEN
SiemensSEN asked
on
Hello,

I install SQLserver 2005 X64 using a domain account. This account has administrator access to the machine. The installation was successful. However, if I remote desktop to the server and open SSMS and then right-click  and re-start then I get the error below


Unable to stop service MSSQL$CQ2005 on server -- AccessDenied(ObjectExplorer)

I can stop SQLserver by going to services and stop or  restart it but not from SSMS
Comment
Watch Question

Top Expert 2011

Commented:
*How* are you sigining into ssms, as an administrator or domain account user?

You should try going in with the same account you used for installing sql server.
Lara FEA
CERTIFIED EXPERT

Commented:
check with what ID and which type (SQL or NT) you setup connection in SSMS.
Right click on server in object explorer and see connection section on buttom left corner

Author

Commented:
I install it as the domain account and SSMS login is the domain user

connection properties
server = usbocc...\cqinstance
connection =
my domain user
Lara FEA
CERTIFIED EXPERT

Commented:
Most likely this domain user does not have sysadmin permission to start/stop SQL server

Author

Commented:
Thanks,
  I look at the login properties for my domain id . The server roles is "public" and "sysadmin"
Lara FEA
CERTIFIED EXPERT

Commented:
1) Can you connect to server with Remote desktop using  your domain ID? When connected with domain ID can you start/stop service?

2) try to reconnect to object explorer and key-in  domain ID

Author

Commented:
Thanks ..but no success

I remote desktop to the SQL server machine using my domain account (appxyz123)
Start SSMS
Servername = myservername\instance
authentication = windows authentication
user name box is disable but contain my domain ID (does not allow me to key in the information)
select connect
-- I am connected ti my sqlServer instance can do all action

ERROR
-- Right-click on the instance in SSMS
-- select restart
--  message box popup from SSMS -- "are you sure you want to restart MSSQL$instancename on myserver
-- select YES
--error box popup -- <unable to stop serviceMSSQL$instancename on server servername>
--------------------------------------------------------------------------------------------------------------------------------

I can go to service area configuration and stop and start the service  the service
Lara FEA
CERTIFIED EXPERT

Commented:
Can you connect with SQL authentication to the server and see if you have start/stop

Also,  check this discussion, may be it helps
http://www.sqlservercentral.com/Forums/Topic506940-149-1.aspx

read response from
"the__t"

Author

Commented:
Ok . I am not sure if this is how it suppose to work.

-- This is windows 2008 server SP1

I remote desktop and login with my domain account
Start SSMS as administrator ("Right click on the icon and select "run as adminsitrator")
SSMS open and it I choose my Windows Authentication and it has my domain account already selected

if I do the above step then I can start and stop the service
EA
CERTIFIED EXPERT
Commented:
Here are more details. Check section about  "Windows Server 2008"

http://technet.microsoft.com/en-us/library/ms345578.aspx
I do not have Widows server 2008 to get more testing.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.