Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unable to connect to remote server

Status
Not open for further replies.

babeo

Technical User
Mar 30, 2000
398
CA
Hi
I have a table that is remotely connected with another server, which I specify the remote server in the host file, but when connecting through isql, and perform a select statement below, I get error. Could someone help me to solve this problem?

Thanks a lot
[red]
1> select * from inv_prd
2> go
Msg 11216, Level 16, State 1:
Server 'mysrv1', Line 1:
Internal Ct-Lib/Cs-Lib error 4002: 'Login failed.
'.
Msg 11206, Level 16, State 1:
Server 'mysrv1', Line 1:
Unable to connect to server 'rmsrv2'.[/red]


When I check the property of the table,inv_prd, I see the line below:
[red]Object is Remote/External
-------------------------
rmsrv2.admin.dbo.inv_prd[/red]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top