August 7, 2010 at 8:24 am
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.
August 7, 2010 at 9:35 am
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
August 7, 2010 at 10:48 am
I second what Jeffrey mentioned. Please run SSMS/Configuration Manager as Administrator.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 9, 2010 at 8:27 pm
Thank both of you!!! i resolved the problem.thank you again!!!
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy