|
|
Posted by Erland Sommarskog on 05/15/06 13:43
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]
|