Post reply

Changing the SQL Server Service Account

  • September 14, 2011 at 10:35 am

    #247646

    Hi

    In our development environment the SQL Server service was set to run under the Local Sytem Account. I wanted to change it to NT AUTHORITY\NETWORK SERVICEaccount. When I change the account and try to restart the service for the change to take effect it fails. The service does not restart. I have to revert to Local System account and then it works fine.

    I have MS SQL Server 2008R2.

    Could you please help me with this?

    Regards

    Parikshit

  • September 14, 2011 at 12:13 pm

    #1381533

    Are you changing the account using SQL Server Configuration manager, or are you doing it from services.msc?

    Thanks,

    Jared

    Jared
    CE - Microsoft

  • September 14, 2011 at 12:15 pm

    #1381534

    I am doing it from services.msc

  • September 14, 2011 at 12:18 pm

    #1381536

    parikshitp (9/14/2011)

    I am doing it from services.msc

    This is probably the reason why. SQL Server Configuration Manager will allow you to change it and give the proper permissions to the account.

    Thanks,

    Jared

    Jared
    CE - Microsoft

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

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