Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Linked Server SQL2012 to SQL2000
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Yak Posting Veteran

62 Posts

Posted - 03/15/2013 :  13:56:32  Show Profile  Reply with Quote
Hi Guys,

SQL2012 is installed on Windows Server 2008 R2. I wanted to install SQL Server Native Drives 10.0 X86 version so that I can create linked server to SQL2000 box. But I am not able to install the native driver (SQLNCLI.msi). The erros is that it is not compatible to Windows Server 200 R2. Is there a workaround for these guys? Any help is appreciated.


Yak Posting Veteran

62 Posts

Posted - 03/15/2013 :  16:21:42  Show Profile  Reply with Quote
When I try to create SYSTEM DSN for ODBC connection, I get this error:
system DSN for ODBC error connect failed SQLSTATE '01000' SQL SERVER ERROR: 11001[MICROSOFT][ODBC SQL SERVER DRIVER][TCP/IP SOCKETS]ConnectionOpen (Connect()). Connection failed: SQLState '08001' SQL Server Error: 6 [MICROSOFT][ODBC SQL SERVER DRIVER][TCP/IP Sockets]Specified SQL Server not found
Go to Top of Page

Most Valuable Yak

15732 Posts

Posted - 03/15/2013 :  16:35:41  Show Profile  Visit robvolk's Homepage  Reply with Quote
If it's not compatible then use another driver, like OLEDB or ODBC. SQL Server 2000 has passed end-of-life support, so current and future drivers won't support it.

Even if DSNs can be used for linked servers, there's no need for them and zero benefit. Learn to write proper connection strings, it's pretty easy:
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000