Solved

How to create a linked server in MS SQL Server 2005 which links to an MS SQL Server 2000 server

Posted on 2008-06-23
3
856 Views
Last Modified: 2011-10-19
I am trying to create a linked server in MS SQL Server 2005 which links to an MS SQL Server 2000
server. I am using the wizard and have attached the details input into the popup screen and a copy of the error message.

One problem is that the client has lost the password for the sa login to SQL Server 2000, so I have to login using 'windows authentication'.
LinkSVR.JPG
Err.JPG
0
Comment
Question by:Vincent_Monaghan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 13

Accepted Solution

by:
MikeWalsh earned 500 total points
ID: 21848038
You are trying to connect to that 2000 instance with whoever is running the SQL Server Service on the 2005 machine.

That login will need to have permission to connect and perform the necessary actions (Be a login, connect to that database, read/write tables exec procs, etc.)

Another option is to use an existing account and click on the security tab and provide a different remote login/password. It doesn't have to be SA it can be any user with the necessary permissions.

If you select "Be Made Using the Login's Current Security Context" for the default connections (For a login not defined in the list above connections will:.. third choice) it should also allow you to connect to the 2000 server with the authentication you have. So if you have proper permissions on each server and select that option you should be good also.
0
 
LVL 14

Expert Comment

by:Jagdish Devaku
ID: 21853045
HI,

Please refer to the following link which might help you in resovling the issue...

http://sequelserver.blogspot.com/2007/06/under-default-settings-sql-server-does.html

All the best...
0
 

Author Closing Comment

by:Vincent_Monaghan
ID: 31469810
Thank you
0

Featured Post

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

615 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