Server: Msg 7399, Level 16, State 1, Line 2 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 'sa'.] OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80040e4d: Authentication failed.].>Your @provstr is incorrect. It's for SQL ODBC driver not OLE DB provider.
>>sp_dropserver 'mss' >>go >> >>sp_addlinkedserver >>@server = 'mss', >>@srvproduct = 'SQLOLEDB', >>@provider = 'SQLOLEDB', >>@provstr = 'DRIVER={SQL Server};SERVER=10.0.0.2;UID=MyID;PWD=MyPWD' >> >>go >> >>select * >> from openquery(jef, 'SELECT * FROM mss..LocFL') >> >>go >>>>I'm trying to connect to a remote server using a different UID & PWD
>>Server: Msg 18456, Level 14, State 1, Line 2 >>Login failed for user 'sa'. >>[OLE/DB provider returned message: Invalid connection string attribute] >>>>