Error: Cannot open database “” requested by the login. The login failed. OLE DB provider “SQLNCLI10” for linked server “” returned message “Invalid connection string attribute”.
Description: When trying to access a linked server with the provided credentials, this error occurs.
Solution: Connectivity issue, the user name which used to connect to the linked server have no rights or permission to access the server. Check the user exists in server with proper rights or permissions else create a new credentials and map to the server.