Hi,
In short, the question is as follows:
Is there any way to make server linking working without Security Account
Delegation enabled if the target (linked) server is set to "Windows only"
authentication?
We've encountered the following problem:
There are two SQL 2000 servers: SERVER1 and SERVER2.
We want to be able to access data stored on SERVER2 from SERVER1.
Therefore we created on SERVER1 a linked server SERVER2 (sp_addlinkedserver
N'SERVER2', N'SQL Server').
If SERVER2 were set to "SQL Server and Windows" authentication we could
easily add a linked server login:
sp_addlinkedsrvlogin @.rmtsrvname = N'SERVER2', @.useself = 'FALSE',
@.locallogin = <some local login>,
@.rmtuser = <SERVER2_SQLLogin>, @.rmtpassword = <password>
However, SERVER2 is set to "Windows only" authentication and we cannot
change it.
How can we establish a link?
Many thanks for any help.
Best regards,
Andrewif the NT logins have access to both servers then you can
use following to give them access to the linked server:
exec sp_addlinkedserver N'SERVER2' , '', @.provider =N'SQLOLEDB' , @.datasrc = N'SERVER2'
EXEC sp_addlinkedsrvlogin 'SERVER2', 'true'
This will use user's current login credentials to access
the linked server.
HTH
>--Original Message--
>Hi,
>In short, the question is as follows:
>Is there any way to make server linking working without
Security Account
>Delegation enabled if the target (linked) server is set
to "Windows only"
>authentication?
>
>We've encountered the following problem:
>There are two SQL 2000 servers: SERVER1 and SERVER2.
>We want to be able to access data stored on SERVER2 from
SERVER1.
>Therefore we created on SERVER1 a linked server SERVER2
(sp_addlinkedserver
>N'SERVER2', N'SQL Server').
>If SERVER2 were set to "SQL Server and Windows"
authentication we could
>easily add a linked server login:
>sp_addlinkedsrvlogin @.rmtsrvname = N'SERVER2',
@.useself = 'FALSE',
>@.locallogin = <some local login>,
> @.rmtuser = <SERVER2_SQLLogin>, @.rmtpassword =<password>
>However, SERVER2 is set to "Windows only" authentication
and we cannot
>change it.
>How can we establish a link?
>Many thanks for any help.
>Best regards,
>Andrew
>
>.
>sql
No comments:
Post a Comment