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 |
|
jrockfl
Posting Yak Master
223 Posts |
 Posted - 2004-10-18 : 09:40:28
|
| We switched to a new domain at work, and my DTS packages are not working. SQL Server Agent was trying to start up with the old credentials, so I corrected that. I changed to owner of the DTS packages to the new domain.I can access the databases, but the DTS keep failing. I'm getting[DBNETLIB][ConnectionOpen(Connect()).] SQL Server does not exist or access denied.Any suggestions? |
|
|
nreinholdt
Starting Member
8 Posts |
Posted - 2004-10-18 : 15:31:46
|
| I had a similar problem that was fixed by deleting the connection object in question and recreating it. You might want to give that a shot.Otherwise I've found myself recreating packages from scratch when moving them. Sorry!nragamuffin |
 |
|
|
jrockfl
Posting Yak Master
223 Posts |
Posted - 2004-10-18 : 16:54:57
|
| Some of them worked fine, while a couple others did not. I ended up just recreating and them and everything works now.Thank you. |
|
|
|
|
|
|
DTS not working after moving to network domain