Re: DisallowAdhocAccess or DisallowAdHocAccess ?

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 11/22/04

  • Next message: Wen Ou: "RE: help! report users permission on a SQL 2000 server" 
    Date: Mon, 22 Nov 2004 15:38:59 -0700

    I 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 ad
    >hoc
    >access then which key should I use (I've seen both forms on MS and in
    >e-mails)?
    >
    >DisallowAdhocAccess or DisallowAdHocAccess
    >
    >
    >Thanks,
    >
    >Stan
    >

  • Next message: Wen Ou: "RE: help! report users permission on a SQL 2000 server"