Recently, I tested a LinkedSErver and received the error: “The object invoked has disconnected from its clients. (Exception from HRESULT: 0x80010108 (RPC_E_DISCONNECTED)) (mscorlib)”
What does this mean? In short, it means your source server (the one the LinkedServer is sitting on) does not have a “Server Principal Name” established in the AD. How do you fix this?
In a DOS window, use the SETSPN command. First verify that this is in fact the issue via:
setspn -L YourSQLServerAccountNameHere
Where YourSQLServerAccountNameHere is the name of the Service account that is running your SQL Server.
If you don’t see your server in the resulting list…then that’s your problem. Adding Server Principal Names is the subject of other blogs.