Allow in process - SQL Server Forums

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.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources