GarryBaker
asked on
Event ID 19011 Source MSSQLServer
Good morning all,
I am getting the following problem on boot up of my SQL servers
Event ID 19011
Source MSSQLServer
Description
SuperSocket info (SpnRegister): Error 8344
The problem seems to be that my service account does not have enought permissions. I have spoken to my DBA and gone through the SQL Server 2000 Security (Service Accounts) documentation he has and the following MS artical Q283811.
The DB service account is a Domain User with the following rights in the Application Server GPO
Act as Part of the Operating System
Bypass Traverse Checking
Lock Pages In Memory
Log on as a Batch Job
Log on as a Service
Replace a Process Level Token
Full control over the following registry entries
HKEY_LOCAL_MACHINE\Softwar e\Clients\ Mail
HKEY_LOCAL_MACHINE\Softwar e\Microsof t\Microsof t SQL Server\80
HKEY_LOCAL_MACHINE\Softwar e\Microsof t\MSSQLSer ver\MSSQLS erver
HKEY_LOCAL_MACHINE\Softwar e\Microsof t\MSSQLSer ver\Provid ers
HKEY_LOCAL_MACHINE\Softwar e\Microsof t\MSSQLSer ver\Replic ation
HKEY_LOCAL_MACHINE\Softwar e\Microsof t\MSSQLSer ver\Setup
HKEY_LOCAL_MACHINE\Softwar e\Microsof t\MSSQLSer ver\SQLSer verAgent
HKEY_LOCAL_MACHINE\Softwar e\Microsof t\MSSQLSer ver\Tracki ng
The user has full control over the Log and data areas on the server and is a memeber of the sysadmin group in enterprise admistrator.
Please can anyone suggest what I might be missing to give this user enough rights to prevent this error.
I am getting the following problem on boot up of my SQL servers
Event ID 19011
Source MSSQLServer
Description
SuperSocket info (SpnRegister): Error 8344
The problem seems to be that my service account does not have enought permissions. I have spoken to my DBA and gone through the SQL Server 2000 Security (Service Accounts) documentation he has and the following MS artical Q283811.
The DB service account is a Domain User with the following rights in the Application Server GPO
Act as Part of the Operating System
Bypass Traverse Checking
Lock Pages In Memory
Log on as a Batch Job
Log on as a Service
Replace a Process Level Token
Full control over the following registry entries
HKEY_LOCAL_MACHINE\Softwar
HKEY_LOCAL_MACHINE\Softwar
HKEY_LOCAL_MACHINE\Softwar
HKEY_LOCAL_MACHINE\Softwar
HKEY_LOCAL_MACHINE\Softwar
HKEY_LOCAL_MACHINE\Softwar
HKEY_LOCAL_MACHINE\Softwar
HKEY_LOCAL_MACHINE\Softwar
The user has full control over the Log and data areas on the server and is a memeber of the sysadmin group in enterprise admistrator.
Please can anyone suggest what I might be missing to give this user enough rights to prevent this error.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
See following ling.
http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic12560.aspx