dbTalk Databases Forums  

Adding users to linked server

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Adding users to linked server in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Danny
 
Posts: n/a

Default Adding users to linked server - 04-19-2007 , 07:18 PM






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,
Danny


Reply With Quote
  #2  
Old   
Paul
 
Posts: n/a

Default Re: Adding users to linked server - 04-20-2007 , 05:58 AM






Hi 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,

Paul


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.