SQL2005/2000 Linked Server Security

Posted on 2011-10-24
Medium Priority
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
  • 4
  • 2
LVL 11

Expert Comment

ID: 37018290
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

ID: 37018580

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

ID: 37018610
SQL 2000 shouldn't be a problem.

Did you include the domain name in the login Id?
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.


Author Comment

ID: 37018690

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

johnnyg123 earned 0 total points
ID: 37072233
never did figure this out

doesn't look like  I explained it well enough

Author Closing Comment

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

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

839 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