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.
| Author |
Topic |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2013-07-11 : 06:17:05
|
Hi All,
I need to create an linked server from sql server 2005 enterprise edition to 2008 server. Pls suggest. I am gettign error.
Source is 32- Bit sql server and 2008 server is 64-Bit. Pls help with script or reference link.
Out-of-process use of OLE DB provider "SQLNCLI" with SQL Server is not supported. (Microsoft SQL Server, Error: 7430)
Thanks,
Gangadhara MS
SQL Developer and DBA |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-11 : 07:23:26
|
Havent seen this myself. Did you try with OLEDB provider instead?
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
|
 |
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2013-07-11 : 08:39:32
|
I have made linked server with SQL server Native client 10.0 ,but while querying i am getting the error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The OLE DB provider "SQLNCLI10" for linked server "" reported an error. Access denied.
Cannot obtain the required interface ("IID_IDBSchemaRowset") from OLE DB provider "SQLNCLI10" for linked server "". (Microsoft SQL Server, Error: 7399)
|
|
|
|
|
|
|
Linked server from SQL server 2005 to 2008