Post reply

SQL Server Registry Keys: where are they?

  • June 24, 2010 at 9:02 pm

    #236963

    Per 2008 training kit:

    To start SQL Server the SQL Server service account needs to have several permissions, including "Read and Write pedrmissions on SQL Server registry keys".

    There is not exercise or instructions for where to find these. Where do I go to check these?

    Thanks.

  • June 24, 2010 at 10:43 pm

    #1184790

    Normally, you shouldn't need to worry about setting permissions on the relevant registry keys. If you use the configuration tools that come with SQL Server to set/change the account used as the service account for SQL Server, they do everything you need

    The keys are actually in

    HKLM\KEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

    The key that you need for a particular instance of SQL depends on the order of installation.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply