November 4, 2008 at 8:07 am
I trying to configure SQL to run with a user account - not administrator account.
I'm running SQL 2k5 with a domain account. I think I've followed all of the security configuration changes for the account, but when trying to restart SQL on one server it fails. (It starts on 2 other servers.)
I went back to review the changes I applied with NTRights & ran ShowPriv for some of the Windows Privledges. Something must have gotten screwed up on this server, because I get errors when running showpriv. Follows is part of the output from ShowPriv:
The LookupAccountSid() API returned error 0x00000534
Since I think NTRights was run on an non-existant account, how do I clean up the settings?
Is it possible this error is causing SQL to not start on this one server?
November 5, 2008 at 6:52 am
I got it. I went to the Local Policies MMC snap-in. There I located the different permission settings I had & then removed the bogus user accounts.
SQL now runs like a champ with a User account.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply