Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yuchieh
Starting Member
2 Posts |
 Posted - 2008-07-23 : 09:41:05
|
| We use SQL server 2000. We have a DTS and a scheduled job to run this DTS nightly. It's to retrieve records from DB1 and insert into a table in DB2. It's been working great until two days ago. Our network people implemented "force change password" policy on staff logins. Since then, the job fails every night, but it's still working if running the DTS along.The DB2 is inside the domain; I don't even know if this is relevant. Here is the job error message --Executed as user: NASW\JGrimes. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147467259 (80004005) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 17 (11) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.Please help!! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-23 : 22:46:19
|
| Check sql connections in the package, change to sql authentication if necessary. |
 |
|
|
yuchieh
Starting Member
2 Posts |
Posted - 2008-07-24 : 08:18:34
|
| We found out that we had to change the password in SQL Service Agent manually for the account used by the agent. It seems ok now.Thank you! :) |
|
|
|
|
|
|
job fail - Error:-2147467259 (80004005)