Post reply

How to add to SQL Server startup account the necessary rights??

  • April 15, 2005 at 12:20 am

    #85531

    After SQL server install there was need to change SQL server startup account. I added a new one, who has local admin rights, but I must add some other rights like increase quotas and other. Where I can change them? In Active directory somewhere or in the server registry or somewhere else?

    Thanks in advance

  • April 15, 2005 at 12:57 am

    #552855

    OK. I found it. It can be done in OS

  • April 15, 2005 at 7:32 am

    #552906

    Typically the best way to do this is to use Enterprise Manager to make the service account change. While you can do everything manually, EM tends to get all the file and registry permissions as well. If you're dealing with AWE memory, there are some things you'll need to set yourself (lock pages in memory, for instance), but generally EM gets it all for you.

    K. Brian Kelley
    @kbriankelley

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

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