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 |
|
qman
Constraint Violating Yak Guru
442 Posts |
 Posted - 2009-11-18 : 14:33:57
|
| We have multiple legacy DTS packages that run fine when executed from the server using SQL 2005. When I attempt to run the same DTS packages on my local machine, they fail with:[DBNETLIB][ConnectionOpen (Connect()).SQL]SQL Server does not exist or access denied.I does not seem to matter weather I am using SQL or Windows Authentication, it fails locally either way.I have found multiple websites mentioning this issue but nothing related to DTS. Many of the sites talk about enabling Named Pipes on the server. I did this but it did not help, we currently have TCP/IP enabled via SQL Server Configuration Manager.Can anyone help with this...? |
|
|
|
|
|
DTS Errors when run from Client Machine.