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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Allow in process

Author  Topic 

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2012-11-22 : 17:39:59
Hi,

Under linked servers providers: which of the following providers should be setup for "allow in process"

1. ADsDSOObject
2. DTSPackageDSO
3. Microsoft.Jet.OLEDB.4.0
4. MSDAORA
5. MSDAOSP
6. MSDMine
7. MSIDXS
8. MSOLAP
9. MSOLAP
10 SQLNCLI
11 SQLOLEDB
12 SQLReplication.OLEDB

srimami
Posting Yak Master

160 Posts

Posted - 2012-11-22 : 23:43:12
Hi Peter,

Are you setting up new linked server? Why do you want to go with 'allow in process'? Liked servers are used to read data from other servers under the same domain. If you are setting up new server, no need to go with 'allow in process'.

Thanks,
Sri.
Go to Top of Page
   

- Advertisement -