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 |
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
 Posted - 2007-08-08 : 16:07:46
|
| I have some DTS packages which were created by a different Login in SQL Server 2000 and these packeges give the error:[dbnetlib] connectionopen connect . sql server not foundwhen executed from client. Any new packages I create with my Login Run Fine from the client. But even when I copy this package with a different name it does not run. When I schedule the DTS with a job the package runs. From any server the package runs. But not from the client. What can be the problem here. I have tried everything listed on the forums about this topic. But the problem is all the new DTS packages Run. Just the ones with this particular user ID do not run from any client but only at server.Ashley Rhodes |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-08-08 : 16:23:25
|
| Open the package and "Save as" with a different name and use SQL authentication (probably a sql service account) so this problem does not repeat. Keep the packages independent of the users. Once the package is saved with a different name, you can delete the original one and again "save as" the original name.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
Posted - 2007-08-09 : 15:34:42
|
| I have already tried this but it does not works for some reason.I had to recreate all the DTS packages created by that user.Even if I copy Paste those DTS packages it does not worksAshley Rhodes |
|
|
|
|
|
|
DTS PACKAGE CREATED BY ANOTHER USER DO NOT RUN FRO