Thursday, March 22, 2012

Adding users to linked server

Is there a certain way of adding users to access a linked server? I
linked to an Oracle server but somehow, I'm unable to add any users,
even after trying in EM. It'll allow me to select the local account,
enter a remote userid/password, click apply save, but doesn't seem
to hold the info.

Please help!

Thanks,
DannyHi Danny,

Might not be much help as I am not 100% sure I know what you want to
do but have you looked at sp_addlinkedsrvlogin?

I use this to create logins for accessing on Oracle instance.

Cheers,

Paulsql

No comments:

Post a Comment