Cannot create a linked server with another SQL server.

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.
bat-manAsked:
Who is Participating?
 
Maciej PileckiConnect With a Mentor Database ArchitectCommented:
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.
0
 
bat-manAuthor Commented:
a reinstall of the machine worked, the above solution , although logical still came up with the same error message!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.