I had this same issue. This is a post I made on www.eventid.net.
In my case, this SQL server was hosting several MOSS 2007 databases. I found that the SQL agent was trying to login to a database that did not exist. MOSS uses SQL Server Jobs to delete expired sessions on a set schedule, every minute, to free up resources that are not being used. You will need to go into SQL Server management studio and disable the job called SharedServices_DB_job_deleteExpiredSessions. Once this is done you should no longer see those error messages in the event log. If you disable the right job, and the error message no longer appears, you can then delete the job. Always disable first. You do not want to delete until you are sure you got the right job. Mark From: James Kerr [mailto:[EMAIL PROTECTED] Sent: 15 July 2008 15:42 To: NT System Admin Issues Subject: Re: WSUS Problem after dcpromo Looks like this is the source of my problems at the moment. I have given access to network service with full control of the WSUS, WSUS database and update services folder. Could this be an SQL problem? Event ID 18456 Source MSSQL$MICROSOFT## Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. [CLIENT: <named pipe>] ----- Original Message ----- From: Anatoly Podgoretsky <mailto:[EMAIL PROTECTED]> To: NT System Admin Issues <mailto:[email protected]> Sent: Tuesday, July 15, 2008 9:57 AM Subject: Re: WSUS Problem after dcpromo You need grant access for Network Service account too. Create login and add user associated with this login. IIS connect to SUSDB with this login Anatoly Podgoretsky http://www.podgoretsky.com ----- Original Message ----- From: James Kerr <mailto:[EMAIL PROTECTED]> To: NT System Admin Issues <mailto:[email protected]> Sent: Tuesday, July 15, 2008 4:42 PM Subject: Re: WSUS Problem after dcpromo Not sure what you mean exactly but I am running the Windows Internal Database service and it is set to logon a local system. Local system has full control of both the WSUS and update services folder. ----- Original Message ----- From: Ken Schaefer <mailto:[EMAIL PROTECTED]> To: NT System Admin Issues <mailto:[email protected]> Sent: Monday, July 14, 2008 9:10 PM Subject: RE: WSUS Problem after dcpromo Grant Network Service permission to login to SQL Server. That shouldn't have been broken by DCPromo, but maybe it's not there for some reason. ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ ****** This email is sent for and on behalf of Inspop.com Limited ****** Authorised and regulated by the Financial Services Authority. Registration no. 310635. Inspop.com Limited (also trading as "Confused.com") is registered in England and Wales at 2nd Floor, Friary House, Greyfriars Road, Cardiff, CF10 3AE (Reg. No. 03857130 ). Any opinions expressed in this email are those of the individual and not necessarily the company. This email and any files transmitted with it, including replies and forwarded copies (which may contain alterations) subsequently transmitted from the Company, are confidential and solely for the use of the intended recipient. It may contain material protected by attorney-client privilege. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this email in error and that any use is strictly prohibited. If you have received this email in error please notify the Information Security Officer by telephone on +44 (0) 29 2043 4200. Please then delete this email and destroy any copies of it. This email has been swept for viruses before leaving our system. Security Warning: Please note that this email has been created in the knowledge that Internet email is not a 100% secure communications medium. We advise that you understand and accept this lack of security when emailing us. Viruses: Although we have taken steps to ensure that this email and any attachments are free from any virus, we advise that in keeping with good computing practice the recipient should ensure they are actually virus free. We may monitor the content of E-mails sent and received via our network for viruses or unauthorised use and for other lawful business purposes. ________________________________________________________________________ This e-mail has been scanned for all viruses by Messagelabs. The service is powered by MessageLabs. ________________________________________________________________________ ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~
