Hi there,

I was trying to create a linked server with NT authentication but I am getting error messages every time I am trying to execute a query. Here is the error message.

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error. Authentication failed.
[OLE/DB provider returned message: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.]


If anybody have any idea to fix it, please let me know.

Thanks

-Faisal Malik