Sunday, May 25, 2008

SQL Service Access Denied

Sunday, May 25, 2008
Today, am having a problem in windows server 2003 SQL database server.Actually, I have two database engine in my server, one is Server/MSFW (Firewall) and another one is Server/SQLEXPRESS.

The server/MSFW database engine has started and connecting perfectly without issues. But, the other one Server/SQLEXPRESS has not started and unable to start manually from SQL Configuration manager and Services.msc. It gave the error message in event viewer is

"UpdateUptimeRegKey: Operating system error 5(Access is denied.)"

Finally, I found the solution on Google :

In Services.msc, Double click on the Service which one you faced issue (Server/SQLEXPRESS) and then click on the 'Log On' tab. Change the 'Log on as' option from 'This account...' to 'Local system account'.

6 comments:

arul said...

Madu maichunu irunda paiyan unakku edukuda SQL elolam

Anonymous said...

hello dhiva,

your help (click on the 'Log on as' option from 'This account...' to 'Local system account'.) works
also for me.

i am very happy about it!
thanks, guido from switzerland

Anonymous said...

Minimal Home With Would you

Here is my website - casino euro

Anonymous said...

Watch The actual key Life For Bees Web based
- Protected, Legal, And Absolutely free?

My web-site aggravation

Anonymous said...

Glass windows 7 Can handle Dolby Electric Plus

My website :: payday loans

Anonymous said...

Thank You...That helped a lot.