linked server security for dummies

From: David Macaskill (david.e.macaskill_at_honeywell.com)
Date: 11/19/03 

Date: 19 Nov 2003 14:19:48 -0800

Hello,

Could someone clarify the Linked Server Properties - Security tab for
me? I didn't find BOL or online help that clear.

I've got SQL Server running on two machines in the same network. On
each machine I've defined a Local Group (someusers) and added my
network username (authority\principal) to it. Then using Enterprise
Manager I added someusers as a login to both machines. On the remote
machine, someusers was the db owner of the database I wanted to
access.

On the remote machine I added a SQL Server login SQLUSER\SQLUSER.

I then tried experimenting with the Security Tab. The only thing I
could get working was by having no mappings and "be made using the
login's current security context" option set - in other words NTLM (I
think).

I guess my question is what other options will work - I thought I
could map someusers (locally) to the (remote) SQLUSER\SQLUSER login
password using the table at the top of the tab but that bounced.

When reading the help I get confused when they refer to
"login/password' - are they talking NTLM or SQL Server Authentication?
When I read "security context" I think NT authentication.

Any advice appreciated.

Thanks.

DEM

Relevant Pages

  • Problems with setting up security tab
    ... When I click on the security tab on the WSAT page (Website/ASP.NET ... "There is a problem with your selected data store. ... to SQL Server database. ... I have SQL Server 2005 running ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: User Login Failed
    ... But after I changed it to Mixed Mode, ... up the security tab again, it's back to Windows only. ... > Does SQL Server allow mixed mode? ...
    (microsoft.public.sqlserver.connect)
  • Re: Unable to start SQL Server
    ... You can also change the password in Enterprise manager by ... security tab. ... >> I have had SQL Server up and running for almost 3 months ... >> I have been disconnected from the network ...
    (microsoft.public.sqlserver.security)
  • Re: SQL sever 2000 security
    ... but there is no security tab on my SQL server 2000. ... "Hassan" wrote: ... >> Database. ...
    (microsoft.public.sqlserver.server)
Quantcast