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 MSSQL 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 MVPhttp://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