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  

 


Posted Feb 04 2008, 12:04 PM by Nadine Storandt
developers.de is a .Net Community Blog powered by daenet GmbH.