MOSS EventLog SQL Login failure EventId 18456

Nadine Storandt — Mon, 04 Feb 2008 11:04:00 GMT

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

- 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

Nadine's Posts : SharedService Provider