cannot restart the sql server

  • I changed sql server authentication at server >properties >security to sql server and windows authentication mode.

    even when ever i try to restart it gives the following error.

    when I am trying to restart the server it gives me error “Unable to stop service MSsql$sqlexpress on server server_name”

    IN additional information it shows that : Access denied(Microsoft.sqlserver.express.objectExplorer). will please suggest me where I made mistake.

    My os is Widows vista. and sql server 2005 I am using.

  • Use configuration manager to restart the services. You can use SSMSE - if you run it as administrator.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • I second what Jeffrey mentioned. Please run SSMS/Configuration Manager as Administrator.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • Thank both of you!!! i resolved the problem.thank you again!!!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply