MS SQL Server DTS - Data Source connection fail in DTS while succeed in Enterprise Man

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Data Source connection fail in DTS while succeed in Enterprise Man

Felix_Jiang

2005-09-26, 3:23 am

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 and password. However, when I try to select the database, it prompts
the error message: [DBNETLIB][ConnetionOpen (Invalid Instance()).]Invalid
connection.
Can anyone help me to solve this problem. Thanks so much!

Sponsored Links