locked
Change SQL Server Service Accounts Passwords RRS feed

  • Question


  • Hi

    We have taken handover of a SQL Server 2014 instance recently. SQL server software was installed using windows account 'Nidadmin'. From SQL Server Configuration manager following service are running under 'Nidadmin' windows account (you can also see green marked field in below picture)-

    - SQL Server analysis service,

    - SQL Server database engine service

    - SQL Server Reporting Service

    - SQL Server Agent

    Now we want to change password of 'Nidadmin' windows account.  

    1) If we change the password of windows account 'Nidadmin' then do we need to update the password in the services from SQL Server Configuration manager? 

    2) Is there any impact in SQL server services if we change the password?

    3) Do we need change anything else anywhere for this?

    4) Do we need to restart SQL server instance?

    5)  Is the password change/update is same for all type of service (database engine, reporting service analysis service, sql server agent)

    In a nutshell we need to change the password of 'Nidadmin' windows account password so that after handover the other team can not login to the database host. Please let us know the above queries feedback?

    • Moved by Naomi N Tuesday, January 10, 2017 9:41 PM Better forum
    Tuesday, January 10, 2017 11:38 AM

All replies

  • Hi,

    instance is clustered or standalone ?

    Refer following link

    https://msdn.microsoft.com/en-in/library/ms365941.aspx?f=255&MSPPError=-2147217396


    Please Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem.

    • Proposed as answer by Dave_Mc Thursday, April 2, 2020 10:21 PM
    Tuesday, January 10, 2017 11:42 AM
  • 1) Yes

    2) Shouldn't be

    3) Not if it's a Windows domain account

    4) Optional for single-node. Required for Cluster node.

    5) As Ekrem pointed out, SSRS password chg must be done with RS Config Mgr

    Hope that helps,


    Phil Streiff, MCDBA, MCITP, MCSA

    • Edited by philfactor Tuesday, January 10, 2017 7:04 PM
    Tuesday, January 10, 2017 12:15 PM
  • Some of your questions in this thread were already replied under another thread again created by you. So I'll skip those same items.

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/5a4a3843-f125-4fdd-8940-d87c2a90c555/change-sql-server-service-accounts?forum=databasedesign#5a4a3843-f125-4fdd-8940-d87c2a90c555

    1- Yes. You need to update your service account password. Otherwise when a service restart occurs, it will fail and will not start and you don't want that.

    2- See item 1 above. Plus a service restart is needed.

    3- If you mean by saying "change" changing service account details, no if you use SQL Server Configuration Manager to update the service account details.

    4- Check your other thread.

    5- Except for Reporting Services, yes. You can use Reporting Services Configuration Manager for this purpose.


    http://ekremonsoy.blogspot.com | http://www.ekremonsoy.com | @EkremOnsoy

    Tuesday, January 10, 2017 12:25 PM
  • Arif,

    If password of domain account changes then same should also be updated in SQL Server related services. When you update the password in services, It will take effect after service restart.

    If your SQL Server is in clustered environment, then you need to do SQL Restart via Fail-over cluster manager ONLY after updating the password in services.

    Also, as per requirement if you want other team should not be able to access this server after the handover, Take a look at all the Logins on SQL Server. You probably want to remove those owned by other team..

    Thanks,


    Kindly mark the reply as answer if they help

    Tuesday, January 10, 2017 12:31 PM
  • Hi Ekrem,

    That thread is for changing  owner of SQL server service account, this thread is for changing password for  SQL server service account.

    Anyway thanks for the reply. Can you explain me about point (5)? 

    Is there will be any issue if I update SQL Server reporting service password through "SQL Server Configuration Manager" instead of  "Reporting Services Configuration Manager"?


    Tuesday, January 10, 2017 5:41 PM
  • Regarding the item 5, you can not do it via SQL Server Configuration Manager even though you insist. Just give it a try and you'll see yourself.

    http://ekremonsoy.blogspot.com | http://www.ekremonsoy.com | @EkremOnsoy

    Tuesday, January 10, 2017 5:53 PM
  • Hi Ekrem,

    I see there is no option to update the password in "SQL Server Configuration Manager" for reporting service. Can you tell me how can I do it through "Reporting Services Configuration Manager"? Steps please.

    Tuesday, January 10, 2017 7:29 PM
  • Please see:

    https://msdn.microsoft.com/en-us/library/ms160340.aspx?f=255&MSPPError=-2147217396

    Tuesday, January 10, 2017 7:51 PM
  • Hi arifulhaq,

    Even though this post of mine is unnecessary, I wanted to reply as you mentioned my name. Please follow the link Tom shared, that's the one you are looking for configuring your Reporting Services service account.


    http://ekremonsoy.blogspot.com | http://www.ekremonsoy.com | @EkremOnsoy

    Tuesday, January 10, 2017 8:01 PM