sql server dts: Scheduled Job Fails with Error: "Login Failed for "sa" -- sql server dts

Re: Scheduled Job Fails with Error: "Login Failed for "sa"

anonymous NO[at]SPAM discussions.microsoft.com
7/14/2004 11:46:55 AM

Yes, we checked that. The strange thing is we can
execute the package successfully but we just can't run it
as a job.

[quoted text, click to view]

Re: Scheduled Job Fails with Error: "Login Failed for "sa"

Rebecca
7/14/2004 2:32:14 PM

Thanks Allan! That did it! Thanks so much for your help!
We had re-created the job but were copying over the same
DTSRun command.

Thanks again!

[quoted text, click to view]

Re: Scheduled Job Fails with Error: "Login Failed for "sa"

Sayonara
7/14/2004 2:41:08 PM

Have you done a complete DTS walkthrough? Check the login/pw's for all bulk
insert and connection tasks. Somewhere in your package the old login is
still being referenced.

[quoted text, click to view]

Re: Scheduled Job Fails with Error: "Login Failed for "sa"

Allan Mitchell
7/14/2004 8:06:19 PM

[quoted text, click to view]

There are two possible areas of problems

1. In the DTS packages themselves you specify sa as the account to use
to logon to servers which you have recently changed the password.

2. This is my best bet. Your SQL Server Agent job that fires the
package looks like this

DTSRun
/~Z0xBBA31C49DCFAC9543989D6EF45E60D7FA2BAF5465E090B679CE824E75B2AF75B22
.........................

This contains the login information you need to connect to the sql
server to get at your package. Unfortunately you probably specified sa
as the logon info and the is now out of date.

You can generate a new string using

Start | Run | DTSRUNUI

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
www.konesans.com - for all your consultancy needs

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.