DisallowAdhocAccess or DisallowAdHocAccess ?

Greetings,
My understanding is that registry items are case sensitive. Please confirm.
If registry entries are case sensitive and I want to use manually disable ad
hoc
access then which key should I use (I've seen both forms on MS and in
e-mails)?
DisallowAdhocAccess or DisallowAdHocAccess
Thanks,
StanI don't think it matters - I've seen it both ways as well.
The Knowledge Base article for the addressing ad hoc issues
has it listed as DisallowAdHocAccess:
http://support.microsoft.com/?id=327489
One easy way to deal with the issue is to make sure you are
on SP3 for SQL Server 2000. With that service pack, the
absence of the key would mean that ad hoc access is not
allowed. Consequently, you don't need to create the key to
disallow ad hoc access if you are running SQL 2000 SP3. If
one exists, you need to make sure it's set to 0.
-Sue
On Fri, 19 Nov 2004 08:03:00 -0500, "Stan Kasper"
<kasper@.wharton.upenn.edu> wrote:

>Greetings,
>My understanding is that registry items are case sensitive. Please confirm
.
>If registry entries are case sensitive and I want to use manually disable a
d
>hoc
>access then which key should I use (I've seen both forms on MS and in
>e-mails)?
>DisallowAdhocAccess or DisallowAdHocAccess
>
>Thanks,
>Stan
>

Disable MSDE Power User installer

Hi,
Is there a way for me to disable the MSDE installer for a Power User?
Some entry in the Registry, perhaps?
Thanks for any help,
Charles
CharlesEF@.MailandNews.Com (Charles E Finkenbiner) wrote in message news:<d55b48cb.0409221952.1c5a1ab8@.posting.google. com>...
> Hi,
> Is there a way for me to disable the MSDE installer for a Power User?
> Some entry in the Registry, perhaps?
>
> Thanks for any help,
> Charles
Hi,
Is there no one that can help me? When I login in as a Power User
MSDE appears to load and run, as I can see the icon in the taskbar.
When I run a certain program (and I use this program many times a day)
the MSDE installer kicks in. If I let it continue it just locks up
and I have to End Task. If I cancel the installer I have to click on
the cancel button 3 times, because the installer dialog pops up 3
times. This has to be done many times a day.
The only option I know of is to uninstall MSDE and find another SQL
program.
Help,
Charles
|||CharlesEF@.MailandNews.Com (Charles E Finkenbiner) wrote in message news:<d55b48cb.0409240008.25d7df6a@.posting.google. com>...
> CharlesEF@.MailandNews.Com (Charles E Finkenbiner) wrote in message news:<d55b48cb.0409221952.1c5a1ab8@.posting.google. com>...
> Hi,
> Is there no one that can help me? When I login in as a Power User
> MSDE appears to load and run, as I can see the icon in the taskbar.
> When I run a certain program (and I use this program many times a day)
> the MSDE installer kicks in. If I let it continue it just locks up
> and I have to End Task. If I cancel the installer I have to click on
> the cancel button 3 times, because the installer dialog pops up 3
> times. This has to be done many times a day.
> The only option I know of is to uninstall MSDE and find another SQL
> program.
>
> Help,
> Charles
Hi All,
I fixed my problem. I had to change permissions for the MSSQLSERVER
tree in the registry. Right or wrong, it worked for me. No more
stupid MSI installer.
Charles