I recently installed SQL Server Integration Services onto one of the nodes of a single cluster thats running windows 2003 enterprise. When I attampt to create a system odbc connection to the database on the cluster, i get a connection failed error.
here is the error:
Connection failed: SQLState: '01000' SQL Server Error: 1326 [Mcirosoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). Connection failed: SQLState: '08001' SQL Server Error: 17 [Microsoft][ODBC SQL Server Driver][DBNETLIB] SQL Serv does not exist or access denied.
however if i attempt to connect to the virtual cluster name, it works.
I need to connect to the single node so that SSIS can be recognized through a client application. Any ideas?
thanks in advance