November 20, 2003 at 2:41 am
When changing the startup account of SQl Server from a system account to a
domain account, get the following error message:
Error 22042: xp_setsqlsecurity() returned error -2147024890 'The handle is invalid'
Can't find any info about the error. Does anyone know how to fix this error and what is causing it?
N.B. Version info:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 6)
November 20, 2003 at 4:10 am
Does the account have proper permissions on the local box and access to the file system especially where the SQL related binaries are installed?
November 20, 2003 at 5:11 am
What do you mean by proper permissions? I read somewhere that SQL server would set up all the permissions automatically or was i just misdunderstood.
November 20, 2003 at 9:22 am
the user that you want to change the sql service account need to be a user at a minimum at your local box.
mom
November 21, 2003 at 10:55 am
SQL Server will create the permissions needed for the account during installation, not on subsequent changes.
November 21, 2003 at 11:02 am
Actually SQL should reset the permissions properly assuming you use EM and you have the permissions to set permissions.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
February 9, 2007 at 9:28 am
You need to use an account that is set to run as a service
Best way to accomplish this is to set which account will be used to run the service (MSSQLSERVER) in:
CONTROL PANEL -> ADMIN TOOLS -> SERVICES
When you add set an NT Account to run a service that NT Account will automatically get set to be able to run as a service.
After that you need to make sure that whatever NT Account your using has sufficient access to the local machine running the SQL Server (an easy way is to add to the Local Admin group of the local machine... or if DC then the Domain Admin group)
That should give you a good start...
September 6, 2007 at 2:44 pm
Did anyone ever come up with a solution for this. I am having the same problem. The machine is a BDC, and I've tried using the domain admistrator account, but still same problem. I tried setting it as the startup account using the services applet first, and then tried it again with EM, but still same problem. How can something this basic and important be so broken even in SP4?
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply