Linked server and Windows authentication

From: Neo (quest02_at_hotmail.com)
Date: 09/04/03 

Date: 3 Sep 2003 17:31:21 -0700

Hello All

We have 2 SQL 2000 Servers A, B under production environment
Server A is running in Mixed mode(Both SQL and Windows auth).
Server B is running under Windows Auth only

While setting up a linked server B on Server A, i get the following
error
-
Error 18452: Login failed for user 'sa'. Reason: Not associated with
trusted login

Someone in this news groups recommended using 'Both SQL and Windows'
authentication for Server B in order to set up the linked server

WE don't have Active Directory setup in the production enviromnent.
The local built-in administrators on both machines have the same
password.

I can logon to ServerA using Windows Auth and use Query Analyser
"Windows Authentication" to connect to the Server B (which is to be
linked)

Why can't i do the same through Lined Server ?
Please help me to understand if its possible to to create a linked
server (using Windows auth) without the Active Directory setup or
security Account Delegation.

--quest

Relevant Pages

  • Re: Setting up Linked server to MsAccess
    ... I'm running SQL Server\Express in "Windows Authenication Mode" (Do I have to ... they are accessing my MS Access linked server? ... Containing folders with MSAccess Database X.mdb ... SQl Express has linked server X mapped via UNC to Database X.mdb ...
    (microsoft.public.sqlserver.security)
  • Re: can MSDE import DBF files?
    ... please state the version of SQL Server being used and the error number/exact ... I just download the SQL books on line. ... > I'm guessing the linked server keeps the data in DBF format but SQL can ... > me to move my clients to the more robust and scalable SQL format. ...
    (microsoft.public.sqlserver.msde)
  • Re: Remote access not allowed for Windows NT user activated by SET
    ... Sql server agent on 2000 server is running under "local system". ... It would be helpful if you scripted out your linked server definitions. ... Sql server agent is running under "Local System account". ...
    (microsoft.public.sqlserver.connect)
  • Linked server from SQL Server to Access db on network share?
    ... I have an Access database that exists on a network share ... that I'm trying to link to as a linked server from SQL ...
    (microsoft.public.sqlserver.server)
  • Linked server from SQL Server to Access db on network share?
    ... I have an Access database that exists on a network share ... that I'm trying to link to as a linked server from SQL ...
    (microsoft.public.sqlserver.programming)