>>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.]. >>>>
>>>>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] >>>>>>>>