[DBNETLIB][Connection Open (Connect()).SQL Error
-
I have an ASP page that connects to a named instance of a SQL2000 database creates a SQL Server Job that in turn runs a DTS package.
The connection string and password are dynamic and passed to the DTS package using Global Variables. Up until this month, the package has been working without problem. However, when I run the package now I get the following message:
[DBNETLIB][Connection Open (Connect()).SQL Server does not exist or access denied.
The strange thing is that when I execute the package as a whole it appears to fail on the first step because none of the steps actually complete but if I run the very first step on its own it works??!!
In terms of things that have changed between last month and this month, here is a list:
1. Our our server was upgraded to SQL Server 2005
2. SQL Server 2005 clients tools were installed on my machine
3. Some passwords have changed but I have also changed all references to the password in the Script steps within the package.
Thanks
-
The package won't fail on the first step when the step is run on it's own as an Execute Step because whatever connection is broken does not need to be checked at that stage.
I take it that there is a datapump task somewhere within the package. I don't currently know what the exact cause of the error is but you could try removing the old connection to the server in the package, creating a new one and redo the mapping for the datapump transformation.
-
Hi Adrian,
Yes there is a data pump task within the package. I shall try what you have suggested and let you know if it resolves the problem.
Thanks
David
-
Check if the coonection property is given right. Packages fail if the connection are not right or modified wrongly.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply