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: 2 days ago @ 2:43 PM
Points: 3,174, Visits: 7,458
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: 2 days ago @ 11:07 AM
Points: 5,322, Visits: 12,596
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: 2 days ago @ 2:55 PM
Points: 19,580, Visits: 17,831
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, January 22, 2016 4:21 PM
Points: 327, Visits: 1,113
Good thorough article, Gianluca.


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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: 2 days ago @ 2:07 PM
Points: 15,016, Visits: 12,988
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