Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Setting up linked servers with an out-of-process OLEDB provider Expand / Collapse
Author
Message
Posted Thursday, June 9, 2011 7:20 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 12:58 PM
Points: 3,562, Visits: 8,243
One of the best articles on the web for configuring linked server connections. The part that describes what specific resources a provider must be granted access to before it will run out-of-process is especially useful, and I'm sure there is a long story with plenty or trial and error. Thanks.


"If you break a few eggs, then make an omelet."
Post #1122484
Posted Thursday, June 9, 2011 7:26 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:11 AM
Points: 5,443, Visits: 12,961
Eric M Russell (6/9/2011)
... I'm sure there is a long story with plenty or trial and error.


...longer than you could ever imagine!
Thank you.


--
Gianluca Sartori

How to post T-SQL questions
spaghettidba.com
@spaghettidba
Post #1122492
Posted Thursday, June 9, 2011 9:29 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, January 19, 2016 12:52 PM
Points: 79, Visits: 357
Excellent, excellent article, Gianluca!

-Grubb
Post #1122660
Posted Thursday, June 9, 2011 9:38 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Wednesday, June 22, 2016 2:24 PM
Points: 19,803, Visits: 18,086
Nice article Gianluca.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1122669
Posted Monday, June 13, 2011 10:10 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, June 10, 2016 4:02 PM
Points: 327, Visits: 1,130
Good thorough article, Gianluca.


Post #1124410
Posted Friday, July 29, 2011 3:42 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 3, 2016 7:09 AM
Points: 15,149, Visits: 13,037
Great article! It helped me solve my linked server problem. (as for some reason the Microsoft OLE DB provider for DB2 didn't want to run InProcess. The bastard )
But so overly complex, Microsoft could spend some time to simplify this...




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1150756
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse