I tried to set up linked server. The target server is MS SQL 2008R2.
It works fine if I set Remote login by sa account.
However, if I use a windows account, it will popup an error.
And I get the following message from log.
Attempting to use an NT account name with SQL Server Authentication
Is there anyway to let linked server use windows authentications ?