authentication failed

Hi.

I wrote a view command on server1 like ..

select dbo.ordr.docnum from Server2.SAP.dbo.ordr where dbo.ordr.docstatus ='o' and

system dispaly a error message is authentication failed. but I use administrator to logon

Server1. how to setup authentication between 2 SQL server?

Thanks

moved to security forum.

|||

I would suggest trying to find out a solution on BOL, here is a good staring point:

· Distributed Queries http://msdn2.microsoft.com/en-us/library/ms188721.aspx

· Distributed Queries Stored Procedures http://msdn2.microsoft.com/en-us/library/ms174359.aspx

Since it seems like you may be using Windows credentials to connect to the 2^nd server, I would also strongly recommend reading the following topic:

· Configuring Linked Servers for Delegation http://msdn2.microsoft.com/en-us/library/ms189580.aspx

Please let us know if this information helped or if you have any additional questions.

Thanks,

-Raul Garcia

SDE/T

SQL Server Engine

|||

Thanks.

I found a topic is "How to create a linked server", so I resolved my problem.

sql