SQL2005/2000 Linked Server Security

Posted on 2011-10-24
Last Modified: 2012-05-12
First let me apologize in advance for being a newbie

There is a linked server entry to a sql 2005 server on my sql 2000 client

Our network team has "locked" down the server so access with existing id no longer works

Since I do have access using by domain account is there a way to use that to get access

I look at the linked server security properties and see the following

Local Login   Impersonate   Remote User  Remote Password

For a login not defined in the list above, connections will:

Not be made

Be made without using a security context

Be made using this security context:

     Remote login:
     With password

Not sure what combination will allow me to access (if any)
using my domain account info

Question by:johnnyg123
    LVL 11

    Expert Comment

    Using the option "Be made using this security context:", and enter your domain account id and password.

    You have to make sure your domain account can access the target database.

    Author Comment


    I get a SQL Server does not exist or access denied.

    On  the sql  server managment login screen I'm using windows authentication so I assume that means my domain account has access to the database

    Did I mention I'm trying to create linked server to a 2005 sql server from the 2000 client?
    LVL 11

    Expert Comment

    SQL 2000 shouldn't be a problem.

    Did you include the domain name in the login Id?

    Author Comment


    Changed the values to protect the innocent but used the following format

    id:  mid\jsmith
    password: testing123

    mid is domain name
    jsmith is id

    Accepted Solution

    never did figure this out

    doesn't look like  I explained it well enough

    Author Closing Comment

    It has been open for awhile and have not received any follow-up

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    The steps for moving the system databases to a new location are documented in the following technical article: However sometimes after the moving process is finished, though SQL i…
    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now