Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 3:20 PM
Points: 2,347, Visits: 6,000
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.
Post #1122484
Posted Thursday, June 9, 2011 7:26 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:27 PM
Points: 5,167, Visits: 12,210
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, June 16, 2015 2:42 PM
Points: 78, Visits: 329
Excellent, excellent article, Gianluca!

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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:27 PM
Points: 18,747, Visits: 16,994
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: Tuesday, June 23, 2015 10:54 AM
Points: 327, Visits: 1,079
Good thorough article, Gianluca.


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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:53 AM
Points: 14,438, Visits: 12,424
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 LessThanDot.

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

Add to briefcase ««12

Permissions Expand / Collapse