December 23, 2003 at 1:58 pm
Is there a reason why I get this error every time a job executes a DTS package on a clustered SQL Server (SQL Server 2000 SP3):
Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0. Process Exit Code 1. The step failed.
The last test I ran was a VBScript with no connection info and I still got this error.
Anyone know why I get this error even when there is no connection info in the DTS package?
Robert W. Marda
SQL Programmer
bigdough.com
The world’s leading capital markets contact database and software platform.
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
December 23, 2003 at 6:38 pm
I assume you have a connection of some sort to actually run a tsql step or a data transform. I would check to see if that connection has (local) in it instead of the actuall sql server instance name.
Wes
December 24, 2003 at 7:34 am
You need to use SQL Server virtual name for the connection.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply