Re: SQL Server does not exist or access denied
- From: jhofmeyr@xxxxxxxxxxxxxx
- Date: Mon, 20 Aug 2007 02:37:41 -0700
On 15 Aug, 17:12, sharman <shar...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
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.
Thanks in advance.
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
.
- Prev by Date: Re: SSIS:how to arrange dtsx into different folder & offline setting problem
- Next by Date: Re: SSIS:how to arrange dtsx into different folder & offline setting problem
- Previous by thread: Is it possible in DTS Transformation Data Task
- Next by thread: Re: Strange error when Executing an SSIS package from a SQL Job
- Index(es):
Relevant Pages
|
