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.
| Author |
Topic |
|
BobRoberts
Posting Yak Master
109 Posts |
 Posted - 2012-02-18 : 22:06:29
|
| I've looked all over and can't get a clear, direct answer to this question: how do you enable the OPENROWSET and OPENDATASOURCE support in SQL 2000? In 2005, it is by "Configuration Tools - SQL Server Surface Area Configuration - Ad Hoc Remote Queries - Check "Enable OPENROWSET and OPENDATASOURCE support". So, is it possible to do the equivalent in SQL server 2000? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-20 : 12:21:46
|
| from BOLhttp://msdn.microsoft.com/en-us/library/aa276845(v=sql.80).aspxRemarksOPENDATASOURCE can be used to access remote data from OLE DB data sources only if the DisallowAdhocAccess registry option is explicitly set to 0. When this option is not set, the default behavior does not allow ad hoc access.http://msdn.microsoft.com/en-us/library/aa276850(v=sql.80).aspxRemarksOPENROWSET can be used to access remote data from OLE DB data sources only if the DisallowAdhocAccess registry option is explicitly set to 0. When this option is not set, the default behavior does not allow ad hoc access------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
BobRoberts
Posting Yak Master
109 Posts |
Posted - 2012-03-02 : 11:16:19
|
| Thanks - those links show the way to fixing the problem. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-02 : 12:40:34
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Enabling OPENROWSET and OPENDATASOURCE Support