[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Cannot create a linked server with another SQL server.

Posted on 2005-04-20
Medium Priority
Last Modified: 2010-03-19
I do not get the option for "Microsoft OLE DB Provider for SQL Server" when trying to create a linked server from my MS SQL server to another MS SQL server, i have the options for Oracle and all the others but not MS SQL server.

Running on XP Professional, with SQL 2000 Personal editon.

Tried to install MDAC 2.8, and the opertaing system will not allow this as it informs me that it(OS) handles it instead.
Question by:bat-man

Accepted Solution

graf0 earned 250 total points
ID: 13822708
The SQL Server optionis just above in the dialog box - there is a radion button that says "SQL Server", you don't have to choose it from the list of OLE DB providers.

Author Comment

ID: 14008416
a reinstall of the machine worked, the above solution , although logical still came up with the same error message!

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

834 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