Change in 'sa' password, scheduled jobs failing
From: Greg (anonymous_at_discussions.microsoft.com)
Date: 04/20/04
- Next message: Antz: "export DB into a flat text file "notepad""
- Previous message: Tom Moreau: "Re: Select Distinct Column"
- Next in thread: Sue Hoegemeier: "Re: Change in 'sa' password, scheduled jobs failing"
- Reply: Sue Hoegemeier: "Re: Change in 'sa' password, scheduled jobs failing"
- Reply: Steve Thompson: "Re: Change in 'sa' password, scheduled jobs failing"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 20 Apr 2004 09:56:02 -0700
Hi all,
I have never come across this one before. I recently changed the 'sa' password. Now all of my scheduled jobs are failing with the error:
DTSRun: Loading... Error: -2147217843 (80040E4D); Provider Error: 18456 (4818) Error string: Login failed for user 'sa'. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0. Process Exit Code 1. The step failed.
I strange thing is that the 'sa' password is not referenced in any connection in any of my DTS Packages. Can anyone shed some light on this. I have hundreds of scheduled jobs and I don't want to have to recreate them all. Thanks.
- Next message: Antz: "export DB into a flat text file "notepad""
- Previous message: Tom Moreau: "Re: Select Distinct Column"
- Next in thread: Sue Hoegemeier: "Re: Change in 'sa' password, scheduled jobs failing"
- Reply: Sue Hoegemeier: "Re: Change in 'sa' password, scheduled jobs failing"
- Reply: Steve Thompson: "Re: Change in 'sa' password, scheduled jobs failing"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
