Link to home
Start Free TrialLog in
Avatar of GarryBaker
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\Software\Clients\Mail
HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\80
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\MSSQLServer
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Providers
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Replication
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Setup
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\SQLServerAgent
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Tracking

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.
Avatar of GarryBaker
GarryBaker

ASKER

OK problem seem to be that the user is unable to register the SPN,  I found a fix saying that you need to confirgure the advanced active directory permission setting to allow the user to Write Public Information.  Does anyone know how to do this and I can seem to be able to find it.

See following ling.

http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic12560.aspx
ASKER CERTIFIED SOLUTION
Avatar of GarryBaker
GarryBaker

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial