MOSS EventLog SQL Login failure EventId 18456

 hey guys,

 if you receive the following error message in your event log you can check some opinions described in this blog post:

SQLServer Error: 18456, Login failed for user ‘DEMO\administrator’

 
This failure mostly came from the SharedService Provider. So please check this options:

 - ensure that all service users has permissions on sql server

• They must be in roles Securityadmin, dbcreator
• And they must be in administrator group of the server
  

- restarting SQL Server Service

- If you have recreated your SharedService Provider have a look at the SQL Management Studio,

• go to the SQL Server Agent and check the jobs
  
• check how many jobs named SharedServices_DB_job_deleteExpiredSessions exists , and  proof which one is from the old sharedService Provider
  
• disable this job at first
  
• restart server
  
• if the failure not ocurred anymore you can delete this job

hope it helps

greets 

nadine