|
Home > Archive > MS SQL Server DTS > September 2005 > Data Source connection fail
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
|
|
| Felix_Jiang 2005-09-29, 3:24 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 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!
| |
| Allan Mitchell 2005-09-29, 7:24 am |
| That's strange as I do this all the time, granted not as an alias
though. Can you specify the ServerName\InstanceN
ame directly in the
connection and get better results?
Allan
"Felix_Jiang" < FelixJiang@discussio
ns.microsoft.com> wrote in message
news:D07152DF-BF6C-4EC6-A2E1- 758498256E4F@microso
ft.com:
> 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.
> Can anyone help me to solve this problem. Thanks so much!
|
|
|
|
|