Data Source connection fail -- sql server dts

Felix_Jiang
9/28/2005 8:27:02 PM

Hey guys,
I encountered a problem recently while working in DTS. I am trying to
connect to a remote SQL Server over network. What I did is as below:
1. In "SQL Server Client Network Utility", and in Alias tab I created
a server alias with remote SQL Server IP address and port configured and
"Network libraries" set to TCP/IP.
2. In Enterprise Manager, I sucessfuly registered this remote SQL
Server with this alias. I connected using SQL Server authentication. I can
access all the tables and views in Remote SQL Server locally.
3. I created a DTS Package and created a new "Microsoft OLE DB
Connection for SQL Server". I set the Data Source (the alias I just created)
and sa password. However, when I try to select the database, it prompts
the error message: [DBNETLIB][ConnetionOpen (Invalid Instance()).]Invalid
connection.

Allan Mitchell
9/29/2005 8:28:54 AM

That's strange as I do this all the time, granted not as an alias
though. Can you specify the ServerName\InstanceName directly in the
connection and get better results?

Allan

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : Data Source connection fail