|
|
Posted by Neil on 05/15/06 19:29
Speaking of linking to a server, is it possible to assign a linked server an
alias at the time it is linked? The reason is that our linked server is a
web server, and it's possible that sometime in the not-too-distant future
its address will change, and, at that point, I'd have to go into the stored
procedures and manually change the server name. Can I assign an alias so
that if a new server has to be linked it can have the same alias?
Thanks.
"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns97C481619B195Yazorman@127.0.0.1...
> Neil (nospam@nospam.net) writes:
>> After creating a linked server to a remote server, I needed to log in
>> using sp_addlinkedsrvlogin to get my stored procedure to work. However,
>> I noticed that after stopping SQL Server and the DTC and then restarting
>> both, that my stored procedure worked without having to execute
>> sp_addlinkedsrvlogin.
>>
>> Is the log-in information stored in the machine, such that if SQL Server
>> is stopped or the server is rebooted, on does not have to execute
>> sp_addlinkedsrvlogin again? Or is there a point at which one would have
>> to re-log-in to a linked server?
>
> You appears to have missunderstood the purpose of sp_addlinkedsrvlogin.
> The
> procedure does not login into the remote server. I have not checked, but I
> would assume that you can run sp_addlinkedsrvlogin without the linked
> server
> being available.
>
> What sp_addlinkedsrvlogin does, as you already have discovered, is to
> store
> information, so that when you issue a query to the linked server, SQL
> Server
> can log in to that data source. So this is a configuration procedure that
> you run once, or possible when you need to give a new user access to the
> linked server.
>
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|