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

adding CALs

I still am unable to figure out how to add additional CALs to SQL Server
2000 and I am not able to get an answer from Microsoft without paying
the $250 to talk to support. Do I actually need to tell SQL that I
purchased more CALs or is it just a paper license'Hi,
Which version of SQL Srver you are currently using ? Is that Personal
edition?
Thanks
Hari
MCDBA
"Brian Rottman" <anonymous@.anonymous.net> wrote in message
news:eyQOr0CDEHA.628@.TK2MSFTNGP10.phx.gbl...
> I still am unable to figure out how to add additional CALs to SQL Server
> 2000 and I am not able to get an answer from Microsoft without paying
> the $250 to talk to support. Do I actually need to tell SQL that I
> purchased more CALs or is it just a paper license'|||SQL Server 2000 Standard

> Hi,
> Which version of SQL Srver you are currently using ? Is that Personal
> edition?
> Thanks
> Hari
> MCDBA
> "Brian Rottman" <anonymous@.anonymous.net> wrote in message
> news:eyQOr0CDEHA.628@.TK2MSFTNGP10.phx.gbl...
>
>
>|||In Control Panel , there should be a applet called License Manager... Run
that program, and If you have installed SQL using per seat , you will see an
option to add licenses for SQL there...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Brian Rottman" <anonymous@.anonymous.net> wrote in message
news:eyQOr0CDEHA.628@.TK2MSFTNGP10.phx.gbl...
> I still am unable to figure out how to add additional CALs to SQL Server
> 2000 and I am not able to get an answer from Microsoft without paying
> the $250 to talk to support. Do I actually need to tell SQL that I
> purchased more CALs or is it just a paper license'|||The only thing I am seeing in License Manager is Windows, nothing for SQL

> In Control Panel , there should be a applet called License Manager... Run
> that program, and If you have installed SQL using per seat , you will see
an
> option to add licenses for SQL there...
>|||This means that SQL Server was not installed with a "per seat" license
option. The only way I am familiar with changing that is to uninstall and
reinstall SQL Server.
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Brian Rottman" <anonymous@.anonymous.net> wrote in message
news:OlHy1UDDEHA.580@.TK2MSFTNGP11.phx.gbl...
> The only thing I am seeing in License Manager is Windows, nothing for SQL
>
Run
see an