September 4, 2011 at 9:57 am
I have created a linked sever and when i am trying to executing command
I got the following message:
OLE DB provider "SQLNCLI" for linked server " B" returned message "Communication link failure".
Msg 10054, Level 16, State 1, Line 0
TCP Provider: An existing connection was forcibly closed by the remote host.
Msg 18452, Level 14, State 1, Line 0
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
can any help me to solve the error...
September 5, 2011 at 12:08 am
Did you check the test connection in ODBC driver? If not please test that first and try executing the same.
September 5, 2011 at 6:03 am
If you are using windows authentication and the account does not exist on the remote SQL Server machine, then when you try to connect your current context doesn't have permissions.
Make sure that the account has the relevant permissions on both servers.
Thanks
Chris
September 6, 2011 at 4:06 am
AM HAVING SYSADMIN PERMISSION ON BOTH THE SERVER.
September 6, 2011 at 5:25 am
This may be a Kerberos delegation issue.
In Active Directory / properties of the user account / Delegation Tab -Is the account set to "Trust this user for delegation to any service (Kerberos Only)"?
In Active Directory / properties of the computer(s) / Delegation Tab -Is the computer set to "Trust this user for delegation to any service (Kerberos Only)"?
If both are set then it may be that the SPN is not registered correctly. This is recorded in the SQL Log would you provide the SQL Log from the last time the servers services where started?
Thanks
Chris
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply