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