Install SQL 2008 Native Client on SQL 2000? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

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

All Forums

General SQL Server Forums

New to SQL Server Administration

Install SQL 2008 Native Client on SQL 2000?

Author

Topic

mar311
Starting Member

9 Posts

Posted - 2011-11-13 : 14:20:19

We have a process where we have various remote SQL servers (not on our domain) accessing data on our local MSSQL 2000 server. we
have used the following query many times in the past with success....

select *
from OPENDATASOURCE(
'SQLOLEDB',
'Data Source=<ip address>;User ID=<username>;Password=<password>
).sales.dbo.stores

(obviously using correct IP and credentials)

Now if I go to a remote MSSQL 2000 or 2005 server, it
runs just fine. However, whenever we run it from MSSQL 2008 server I get the following error:

OLE DB provider "SQLNCLI10" for linked server "(null)" returned message "Unable to complete login process
due to delay in opening server connection".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "SQLNCLI10" for linked server "(null)".

We know we're using the correct IP and credentials because we're able to cut and paste into 2 different
locations through RDP to test this and it works fine on the MSSQL 2005 server but not on MSSQL 2008 server.

Someone had said we need to install the MSSQL 2008 Native Client on the MSSQL 2000 server in order for the above to work. Does this sound accurate?
If so, this would be a production server so what are the risks? Are there any redflags or known issues with installing MSSQL 2008 Native Client on a MSSQL

2000 server? We are just concerned that it may take our production machine down but we wanted to research and confirm within forum first before attempting

this solution.

Any help, input or guidance would be greatly appreciated! Thanks!

mar311
Starting Member

9 Posts

Posted - 2011-11-15 : 10:57:03

Moderator - did I post this in the wrong forum? Should I have put this in the SQL Server Administration 2008 or 2000 forum? Just want to make sure it's in the right place to field responses.

garyn
Starting Member

5 Posts

Posted - 2011-11-15 : 14:44:06

This is a long shot that worked for different but vaguely similar symptoms for me: http://support.microsoft.com/kb/906954.

mar311
Starting Member

9 Posts

Posted - 2011-11-16 : 16:32:13

Thanks garyn.

The install went fine without any hitches. But now we're trying to connect back to our MSSQL 2000 server with the query noted at the top of this thread and are continuing to this error msg:

OLE DB provider "SQLNCLI10" for linked server "(null)" returned message "Unable to complete login process due to delay in opening server connection".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "SQLNCLI10" for linked server "(null)".

Any ideas as to what could be causing this? Any help would be appreciated!

garyn
Starting Member

5 Posts

Posted - 2011-11-17 : 00:56:22

I have not seen this error. I see one successful resolution via firewall adjustment at http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/dc1edde1-87a4-4d43-82b4-ead1a3ab38bd, but I imagine you have already verified you can do simple (non-OPENDATASOURCE()) queries through the linked server.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources