asked on

cannot stop or start SQLserver from SSMS

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

sammySeltzer

*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 F

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

SiemensSEN

ASKER

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

connection properties
server = usbocc...\cqinstance
connection =
my domain user

Lara F

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

SiemensSEN

ASKER

Thanks,
I look at the login properties for my domain id . The server roles is "public" and "sysadmin"

Lara F

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

SiemensSEN

ASKER

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 F

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"

SiemensSEN

ASKER

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

ASKER CERTIFIED SOLUTION

Lara F

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial