| Robert Lie 2005-06-23, 9:23 am |
| Dear All,
I have 2 SQL Server Computers let say SQL1 and SQL2.
I created linked server from SQL1 connect to SQLL2, and it successfuly
running distributed query from SQL1.
Ex : SELECT * FROM SQL2.PROJECT1.DBO.TABLE1
Then I created linked server from SQL2 connect to SQL1, but it failed
running distribued query from SQL2.
Ex : SELECT * FROM SQL1.PROJECT1.DBO.TABLE1
Both linked server setting are using impersonated option on the Security
tab of the Linked Server Properties.
I have check the setspn, and here's the result:
Execution on SQL1 Computer
C:>SETSPN -L SQL2
Registered ServicePrincipalName
s for CN=SQL2,CN=Computers
,DC=abc,DC=co,DC
=id:
MSOLAPSvc/SQL2
MSOLAPSvc/SQL2.abc.co.id
SMTPSVC/SQL2.abc.co.id
SMTPSVC/SQL2
HOST/SQL2
HOST/SQL2.abc.co.id
Execution on SQL2 Computer
C:>SETSPN -L SQL1
Registered ServicePrincipalName
s for CN=SQL1,CN=Computers
,DC=abc,DC=co,
DC=id:
MSSQLSvc/SQL1.abc.co.id:1433
SMTPSVC/SQL1
SMTPSVC/SQL1.abc.co.id
NtFrs-88f5d2bd-b646-11d2-a6d3-00c04fc9b232/SQL1.abc.co.id
HOST/SQL1
HOST/SQL1.abc.co.id
--- You can see the difference (ex port and without port)
Does someone can help me what should I do to make linked server from
SQL2 works, so i can run distributed queries from it.
Thanks
Robert Lie
|