SQL Server does not exist or access denied -- sql server dts

sharman
8/15/2007 9:12:07 AM

Hi,

I am having a problem with a DTS in which I run SQL statements choosing
different connections. I have added a new Production server and I created a
new connection for that. Now whenever I try to run the step using the new
connection I get this error:

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.

I do know that the SQL Server is up and running and it shows up on the
Enterprise Manager. I have some other DTS packages where I pass the New
server name during runtime using Dynamic Properties task and they run
successfully. It is only here in thsi package where I run the steps after
changing the connections that I get this error message.

jhofmeyr NO[at]SPAM googlemail.com
8/20/2007 2:37:41 AM

[quoted text, click to view]

It's difficult to diagnose this type of issue without access to the
environment, but I'd suggest doing the following:

1) Check for typos - sounds silly, but I think most people have
occassionally been caught out by a simple typo in a connection string
2) Check permissions - you say that you have managed to connect
successfully using other packages so the permissions are probably set
correctly, however you should check that the connection is using the
correct credentials to connect to the server. If you're using
integrated security, check whether the package is using your account
or a service account to execute, etc.

Good luck
J

sql server dts : SQL Server does not exist or access denied