Sunday, May 25, 2008

SQL Service Access Denied

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:

  1. Madu maichunu irunda paiyan unakku edukuda SQL elolam

    ReplyDelete
  2. 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

    ReplyDelete
  3. Minimal Home With Would you

    Here is my website - casino euro

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

    My web-site aggravation

    ReplyDelete
  5. Glass windows 7 Can handle Dolby Electric Plus

    My website :: payday loans

    ReplyDelete
  6. Thank You...That helped a lot.

    ReplyDelete