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 |
|
bbasir
Yak Posting Veteran
76 Posts |
 Posted - 2008-03-27 : 13:24:22
|
| I am getting the following error and msft states that some key is missing on my sql server....error that I am getting:-FIX: Ad Hoc Access Incorrectly Permitted If DisallowAdhocAccess Registry Key Is Missingthe provider key that is missing is as follows:- ('Microsoft.Jet.OLEDB.4.0') They say to check the following and see if teh above oledb provider key is missing:-HKEY_LOCAL_MACHINE\Software\Microsoft\\Providers However I already have SP 4 on sql server 2000, am not sure why the key would be missing as the latest server pack should have fixed the issue i.e. after sp 3...the below is help frommsft web site...HKEY_LOCAL_MACHINE\Software\Microsoft\<Instance name>\Providers\<Provider name>where <Instance name> is the name of the instance of SQL Server (MSSQLServer for the default instance) and <Provider name> is the name of the OLE DB provider that is specified in the OPENROWSET or the OPENDATASOURCE function. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-27 : 22:31:30
|
| Tried reinstall latest mdac? |
 |
|
|
|
|
|
How to add provider key? HKEY_LOCAL_MACHINE\Softwa