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]
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]