[crossposted from MS SQL]


i want to set Oracle as a linked server to my MS SQL.
When I execute

EXEC sp_addlinkedserver
@server = 'ORATEST',

and then trying to make sample select, I get the following:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' reported an error. Authentication failed.
[OLE/DB provider returned message: ORA-01017: invalid username/password; logon denied]
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80040e4d: Authentication failed.].

Please advice, where can I set up the username and password for my Oracle, so the things will work.