Change SQL Server service account without restarting SQL ServerChange SQL Server settings without restarting...

How do I write a maintainable, fast, compile-time bit-mask in C++?

What is the name of this perspective and how is it constructed?

Is it common to refer to someone as "Prof. Dr. [LastName]"?

Is Screenshot Time-tracking Common?

How to play songs that contain one guitar when we have two or more guitarists?

Was Opportunity's last message to Earth "My battery is low and it's getting dark"?

Have any astronauts or cosmonauts died in space?

Now...where was I?

Why is Bernie Sanders maximum accepted donation on actblue $5600?

Why do we divide Permutations to get to Combinations?

How can changes in personality/values of a person who turned into a vampire be explained?

What does it mean when an external ID field follows a DML Statement?

Why are "square law" devices important?

What is formjacking?

Why are `&array` and `array` pointing to the same address?

How can I differentiate duration vs starting time

How do I add a strong "onion flavor" to the biryani (in restaurant style)?

Why is quixotic not Quixotic (a proper adjective)?

Question: "Are you hungry?" Answer: "I feel like eating."

How can I make my enemies feel real and make combat more engaging?

What does an unprocessed RAW file look like?

Can you wish for more wishes from an Efreeti bound to service via an Efreeti Bottle?

Found a major flaw in paper from home university – to which I would like to return

Can a Hydra make multiple opportunity attacks at once?



Change SQL Server service account without restarting SQL Server


Change SQL Server settings without restarting servicesChanging the SQL Server service account - any additional considerations?SQL Server starts normally from Windows Services screen, but shows error through SQL Server Configuration Manager. Why?Changing SQL Server service accountChanging SQL Server service account passwords enterprise-wideSQL Server service account change from virtual account to AD accountSSRS and Managed Service Account - impossible to configure?What are points to consider when replacing the SQL Server service account?Changing Service Account password in SQL Server - ClarificationRevert to using local account for SQL Server services













0















For security reasons, we want to change the password that starts the SQL Server service everyday. Is it possible to do this without restarting the service?



If it is possible will the changes be immediately applied, or will I eventually need to restart the service to get the new password?



We were thinking of doing this change in the services option of the windows OS and not in SQL Server configuration manager.










share|improve this question




















  • 4





    You might want to consider this Group Managed Service Accounts (gMSA) and SQL Server 2016

    – SqlWorldWide
    Feb 6 at 19:54






  • 1





    This sounds like a classic XY problem - add details to your question showing what security issue you are attempting to alleivate, why you want to change the password every day, and what you think that will buy you without restarting the instance.

    – Max Vernon
    Feb 6 at 21:03











  • To further the "XY Problem" comment, why are you using a service account with a password in the first place? Best practice is to use a virtual account (or NETWORK SERVICE if using Windows Server 2008). See docs.microsoft.com/en-us/sql/database-engine/configure-windows/…

    – Greenstone Walker
    Feb 6 at 22:44
















0















For security reasons, we want to change the password that starts the SQL Server service everyday. Is it possible to do this without restarting the service?



If it is possible will the changes be immediately applied, or will I eventually need to restart the service to get the new password?



We were thinking of doing this change in the services option of the windows OS and not in SQL Server configuration manager.










share|improve this question




















  • 4





    You might want to consider this Group Managed Service Accounts (gMSA) and SQL Server 2016

    – SqlWorldWide
    Feb 6 at 19:54






  • 1





    This sounds like a classic XY problem - add details to your question showing what security issue you are attempting to alleivate, why you want to change the password every day, and what you think that will buy you without restarting the instance.

    – Max Vernon
    Feb 6 at 21:03











  • To further the "XY Problem" comment, why are you using a service account with a password in the first place? Best practice is to use a virtual account (or NETWORK SERVICE if using Windows Server 2008). See docs.microsoft.com/en-us/sql/database-engine/configure-windows/…

    – Greenstone Walker
    Feb 6 at 22:44














0












0








0








For security reasons, we want to change the password that starts the SQL Server service everyday. Is it possible to do this without restarting the service?



If it is possible will the changes be immediately applied, or will I eventually need to restart the service to get the new password?



We were thinking of doing this change in the services option of the windows OS and not in SQL Server configuration manager.










share|improve this question
















For security reasons, we want to change the password that starts the SQL Server service everyday. Is it possible to do this without restarting the service?



If it is possible will the changes be immediately applied, or will I eventually need to restart the service to get the new password?



We were thinking of doing this change in the services option of the windows OS and not in SQL Server configuration manager.







sql-server security configuration-manager






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited 7 mins ago









jadarnel27

5,46811937




5,46811937










asked Feb 6 at 19:51









Andres ArangoAndres Arango

82




82








  • 4





    You might want to consider this Group Managed Service Accounts (gMSA) and SQL Server 2016

    – SqlWorldWide
    Feb 6 at 19:54






  • 1





    This sounds like a classic XY problem - add details to your question showing what security issue you are attempting to alleivate, why you want to change the password every day, and what you think that will buy you without restarting the instance.

    – Max Vernon
    Feb 6 at 21:03











  • To further the "XY Problem" comment, why are you using a service account with a password in the first place? Best practice is to use a virtual account (or NETWORK SERVICE if using Windows Server 2008). See docs.microsoft.com/en-us/sql/database-engine/configure-windows/…

    – Greenstone Walker
    Feb 6 at 22:44














  • 4





    You might want to consider this Group Managed Service Accounts (gMSA) and SQL Server 2016

    – SqlWorldWide
    Feb 6 at 19:54






  • 1





    This sounds like a classic XY problem - add details to your question showing what security issue you are attempting to alleivate, why you want to change the password every day, and what you think that will buy you without restarting the instance.

    – Max Vernon
    Feb 6 at 21:03











  • To further the "XY Problem" comment, why are you using a service account with a password in the first place? Best practice is to use a virtual account (or NETWORK SERVICE if using Windows Server 2008). See docs.microsoft.com/en-us/sql/database-engine/configure-windows/…

    – Greenstone Walker
    Feb 6 at 22:44








4




4





You might want to consider this Group Managed Service Accounts (gMSA) and SQL Server 2016

– SqlWorldWide
Feb 6 at 19:54





You might want to consider this Group Managed Service Accounts (gMSA) and SQL Server 2016

– SqlWorldWide
Feb 6 at 19:54




1




1





This sounds like a classic XY problem - add details to your question showing what security issue you are attempting to alleivate, why you want to change the password every day, and what you think that will buy you without restarting the instance.

– Max Vernon
Feb 6 at 21:03





This sounds like a classic XY problem - add details to your question showing what security issue you are attempting to alleivate, why you want to change the password every day, and what you think that will buy you without restarting the instance.

– Max Vernon
Feb 6 at 21:03













To further the "XY Problem" comment, why are you using a service account with a password in the first place? Best practice is to use a virtual account (or NETWORK SERVICE if using Windows Server 2008). See docs.microsoft.com/en-us/sql/database-engine/configure-windows/…

– Greenstone Walker
Feb 6 at 22:44





To further the "XY Problem" comment, why are you using a service account with a password in the first place? Best practice is to use a virtual account (or NETWORK SERVICE if using Windows Server 2008). See docs.microsoft.com/en-us/sql/database-engine/configure-windows/…

– Greenstone Walker
Feb 6 at 22:44










3 Answers
3






active

oldest

votes


















0














I would not go through group managed service accounts initially, depending on the issue, environment you are dealing with.



I am not sure what version of sql and the type of security issues you have, but from previous experience permissions to sql server service and agent accounts take affect after a restarting of the service.



I would rather use the sql server configuration manager whenever possible



If you are concerned about security you most definetely need to be able to restart this service, and if that is not possible, then your environment is asking for a good availability group configured, so you are always on, because you need to bear in mind you need patching your servers on a regular basis, and that requires reboots most of the time.



Please review what is preventing your from restarting and address that with management.






share|improve this answer































    6















    ...for security reasons we want to change the password that starts the sql server service everyday




    I realize this is probably outside your control, but it's worth mentioning that this is not a good idea for security. It's a high process overhead for your organization (even if it's generally automated in some way), and it will likely lead to increased chances of some kind of password breach.



    Think about it like this: every time you open the bank vault, there is a risk that some malicious person can get inside. Would you rather open the vault every single day and change the locks, or open it occasionally and keep a really big lock on it (long, secure password).



    Accessing the password every day (to change it, and then apply it to the service account) is like this. You should very a very secure password over changing the password frequently.





    If you are required to do this, though - why don't you want to use SQL Server Configuration Manager? That is the recommended method per the docs:



    SQL Server Configuration Manager - Changing the Accounts Used by the Services




    Always use SQL Server tools such as SQL Server Configuration Manager to change the account used by the SQL Server or SQL Server Agent services, or to change the password for the account. In addition to changing the account name, SQL Server Configuration Manager performs additional configuration such as setting permissions in the Windows Registry so that the new account can read the SQL Server settings. Other tools such as the Windows Services Control Manager can change the account name but do not change associated settings. If the service cannot access the SQL Server portion of the registry the service may not start properly.




    Emphasis added by me. So doing this outside of the service can cause reliability issues with your database engine.



    Regarding avoiding a restart, using the configuration manager accomplishes this goal as well:




    As an additional benefit, passwords changed using SQL Server Configuration Manager, SMO, or WMI take affect immediately without restarting the service.




    Of course, as other answers have mentioned, you should be allowed to restart the service from time to time (Windows Updates, etc).






    share|improve this answer


























    • If you do the change in SQL Server configuration manager it will inmediately prompt the user the next message "This will cause the service to be restarted. Do you want to continue?"

      – Andres Arango
      Feb 6 at 20:12











    • Thank you for your answer, you are correct in many points im also against the change of the password specialy every day, but the points you and other users give me, will help to stablish a good discussion of the cons and little benefits this could do

      – Andres Arango
      Feb 7 at 1:36



















    1















    for security reasons we want to change the password that starts the sql server service everyday




    Why is sql server service restarted everyday ? Just before you restart the service, you can use dbatools - Update-DbaServiceAccount to update the password for the sql server service account.



    e.g. Below Changes the current service account's password of the service MSSQL$MYINSTANCE to 'Qwerty1234'



    $SecurePassword = ConvertTo-SecureString 'Qwerty1234' -AsPlainText -Force
    Update-DbaServiceAccount -ComputerName sql1 -ServiceName 'MSSQL$MYINSTANCE' -SecurePassword $SecurePassword





    share|improve this answer
























    • Interesting I'll check this one

      – Andres Arango
      Feb 7 at 1:37











    Your Answer








    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "182"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: false,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: null,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f229082%2fchange-sql-server-service-account-without-restarting-sql-server%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    3 Answers
    3






    active

    oldest

    votes








    3 Answers
    3






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    I would not go through group managed service accounts initially, depending on the issue, environment you are dealing with.



    I am not sure what version of sql and the type of security issues you have, but from previous experience permissions to sql server service and agent accounts take affect after a restarting of the service.



    I would rather use the sql server configuration manager whenever possible



    If you are concerned about security you most definetely need to be able to restart this service, and if that is not possible, then your environment is asking for a good availability group configured, so you are always on, because you need to bear in mind you need patching your servers on a regular basis, and that requires reboots most of the time.



    Please review what is preventing your from restarting and address that with management.






    share|improve this answer




























      0














      I would not go through group managed service accounts initially, depending on the issue, environment you are dealing with.



      I am not sure what version of sql and the type of security issues you have, but from previous experience permissions to sql server service and agent accounts take affect after a restarting of the service.



      I would rather use the sql server configuration manager whenever possible



      If you are concerned about security you most definetely need to be able to restart this service, and if that is not possible, then your environment is asking for a good availability group configured, so you are always on, because you need to bear in mind you need patching your servers on a regular basis, and that requires reboots most of the time.



      Please review what is preventing your from restarting and address that with management.






      share|improve this answer


























        0












        0








        0







        I would not go through group managed service accounts initially, depending on the issue, environment you are dealing with.



        I am not sure what version of sql and the type of security issues you have, but from previous experience permissions to sql server service and agent accounts take affect after a restarting of the service.



        I would rather use the sql server configuration manager whenever possible



        If you are concerned about security you most definetely need to be able to restart this service, and if that is not possible, then your environment is asking for a good availability group configured, so you are always on, because you need to bear in mind you need patching your servers on a regular basis, and that requires reboots most of the time.



        Please review what is preventing your from restarting and address that with management.






        share|improve this answer













        I would not go through group managed service accounts initially, depending on the issue, environment you are dealing with.



        I am not sure what version of sql and the type of security issues you have, but from previous experience permissions to sql server service and agent accounts take affect after a restarting of the service.



        I would rather use the sql server configuration manager whenever possible



        If you are concerned about security you most definetely need to be able to restart this service, and if that is not possible, then your environment is asking for a good availability group configured, so you are always on, because you need to bear in mind you need patching your servers on a regular basis, and that requires reboots most of the time.



        Please review what is preventing your from restarting and address that with management.







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Feb 6 at 20:12









        marcello miorellimarcello miorelli

        5,7751962136




        5,7751962136

























            6















            ...for security reasons we want to change the password that starts the sql server service everyday




            I realize this is probably outside your control, but it's worth mentioning that this is not a good idea for security. It's a high process overhead for your organization (even if it's generally automated in some way), and it will likely lead to increased chances of some kind of password breach.



            Think about it like this: every time you open the bank vault, there is a risk that some malicious person can get inside. Would you rather open the vault every single day and change the locks, or open it occasionally and keep a really big lock on it (long, secure password).



            Accessing the password every day (to change it, and then apply it to the service account) is like this. You should very a very secure password over changing the password frequently.





            If you are required to do this, though - why don't you want to use SQL Server Configuration Manager? That is the recommended method per the docs:



            SQL Server Configuration Manager - Changing the Accounts Used by the Services




            Always use SQL Server tools such as SQL Server Configuration Manager to change the account used by the SQL Server or SQL Server Agent services, or to change the password for the account. In addition to changing the account name, SQL Server Configuration Manager performs additional configuration such as setting permissions in the Windows Registry so that the new account can read the SQL Server settings. Other tools such as the Windows Services Control Manager can change the account name but do not change associated settings. If the service cannot access the SQL Server portion of the registry the service may not start properly.




            Emphasis added by me. So doing this outside of the service can cause reliability issues with your database engine.



            Regarding avoiding a restart, using the configuration manager accomplishes this goal as well:




            As an additional benefit, passwords changed using SQL Server Configuration Manager, SMO, or WMI take affect immediately without restarting the service.




            Of course, as other answers have mentioned, you should be allowed to restart the service from time to time (Windows Updates, etc).






            share|improve this answer


























            • If you do the change in SQL Server configuration manager it will inmediately prompt the user the next message "This will cause the service to be restarted. Do you want to continue?"

              – Andres Arango
              Feb 6 at 20:12











            • Thank you for your answer, you are correct in many points im also against the change of the password specialy every day, but the points you and other users give me, will help to stablish a good discussion of the cons and little benefits this could do

              – Andres Arango
              Feb 7 at 1:36
















            6















            ...for security reasons we want to change the password that starts the sql server service everyday




            I realize this is probably outside your control, but it's worth mentioning that this is not a good idea for security. It's a high process overhead for your organization (even if it's generally automated in some way), and it will likely lead to increased chances of some kind of password breach.



            Think about it like this: every time you open the bank vault, there is a risk that some malicious person can get inside. Would you rather open the vault every single day and change the locks, or open it occasionally and keep a really big lock on it (long, secure password).



            Accessing the password every day (to change it, and then apply it to the service account) is like this. You should very a very secure password over changing the password frequently.





            If you are required to do this, though - why don't you want to use SQL Server Configuration Manager? That is the recommended method per the docs:



            SQL Server Configuration Manager - Changing the Accounts Used by the Services




            Always use SQL Server tools such as SQL Server Configuration Manager to change the account used by the SQL Server or SQL Server Agent services, or to change the password for the account. In addition to changing the account name, SQL Server Configuration Manager performs additional configuration such as setting permissions in the Windows Registry so that the new account can read the SQL Server settings. Other tools such as the Windows Services Control Manager can change the account name but do not change associated settings. If the service cannot access the SQL Server portion of the registry the service may not start properly.




            Emphasis added by me. So doing this outside of the service can cause reliability issues with your database engine.



            Regarding avoiding a restart, using the configuration manager accomplishes this goal as well:




            As an additional benefit, passwords changed using SQL Server Configuration Manager, SMO, or WMI take affect immediately without restarting the service.




            Of course, as other answers have mentioned, you should be allowed to restart the service from time to time (Windows Updates, etc).






            share|improve this answer


























            • If you do the change in SQL Server configuration manager it will inmediately prompt the user the next message "This will cause the service to be restarted. Do you want to continue?"

              – Andres Arango
              Feb 6 at 20:12











            • Thank you for your answer, you are correct in many points im also against the change of the password specialy every day, but the points you and other users give me, will help to stablish a good discussion of the cons and little benefits this could do

              – Andres Arango
              Feb 7 at 1:36














            6












            6








            6








            ...for security reasons we want to change the password that starts the sql server service everyday




            I realize this is probably outside your control, but it's worth mentioning that this is not a good idea for security. It's a high process overhead for your organization (even if it's generally automated in some way), and it will likely lead to increased chances of some kind of password breach.



            Think about it like this: every time you open the bank vault, there is a risk that some malicious person can get inside. Would you rather open the vault every single day and change the locks, or open it occasionally and keep a really big lock on it (long, secure password).



            Accessing the password every day (to change it, and then apply it to the service account) is like this. You should very a very secure password over changing the password frequently.





            If you are required to do this, though - why don't you want to use SQL Server Configuration Manager? That is the recommended method per the docs:



            SQL Server Configuration Manager - Changing the Accounts Used by the Services




            Always use SQL Server tools such as SQL Server Configuration Manager to change the account used by the SQL Server or SQL Server Agent services, or to change the password for the account. In addition to changing the account name, SQL Server Configuration Manager performs additional configuration such as setting permissions in the Windows Registry so that the new account can read the SQL Server settings. Other tools such as the Windows Services Control Manager can change the account name but do not change associated settings. If the service cannot access the SQL Server portion of the registry the service may not start properly.




            Emphasis added by me. So doing this outside of the service can cause reliability issues with your database engine.



            Regarding avoiding a restart, using the configuration manager accomplishes this goal as well:




            As an additional benefit, passwords changed using SQL Server Configuration Manager, SMO, or WMI take affect immediately without restarting the service.




            Of course, as other answers have mentioned, you should be allowed to restart the service from time to time (Windows Updates, etc).






            share|improve this answer
















            ...for security reasons we want to change the password that starts the sql server service everyday




            I realize this is probably outside your control, but it's worth mentioning that this is not a good idea for security. It's a high process overhead for your organization (even if it's generally automated in some way), and it will likely lead to increased chances of some kind of password breach.



            Think about it like this: every time you open the bank vault, there is a risk that some malicious person can get inside. Would you rather open the vault every single day and change the locks, or open it occasionally and keep a really big lock on it (long, secure password).



            Accessing the password every day (to change it, and then apply it to the service account) is like this. You should very a very secure password over changing the password frequently.





            If you are required to do this, though - why don't you want to use SQL Server Configuration Manager? That is the recommended method per the docs:



            SQL Server Configuration Manager - Changing the Accounts Used by the Services




            Always use SQL Server tools such as SQL Server Configuration Manager to change the account used by the SQL Server or SQL Server Agent services, or to change the password for the account. In addition to changing the account name, SQL Server Configuration Manager performs additional configuration such as setting permissions in the Windows Registry so that the new account can read the SQL Server settings. Other tools such as the Windows Services Control Manager can change the account name but do not change associated settings. If the service cannot access the SQL Server portion of the registry the service may not start properly.




            Emphasis added by me. So doing this outside of the service can cause reliability issues with your database engine.



            Regarding avoiding a restart, using the configuration manager accomplishes this goal as well:




            As an additional benefit, passwords changed using SQL Server Configuration Manager, SMO, or WMI take affect immediately without restarting the service.




            Of course, as other answers have mentioned, you should be allowed to restart the service from time to time (Windows Updates, etc).







            share|improve this answer














            share|improve this answer



            share|improve this answer








            edited Feb 6 at 21:04

























            answered Feb 6 at 20:06









            jadarnel27jadarnel27

            5,46811937




            5,46811937













            • If you do the change in SQL Server configuration manager it will inmediately prompt the user the next message "This will cause the service to be restarted. Do you want to continue?"

              – Andres Arango
              Feb 6 at 20:12











            • Thank you for your answer, you are correct in many points im also against the change of the password specialy every day, but the points you and other users give me, will help to stablish a good discussion of the cons and little benefits this could do

              – Andres Arango
              Feb 7 at 1:36



















            • If you do the change in SQL Server configuration manager it will inmediately prompt the user the next message "This will cause the service to be restarted. Do you want to continue?"

              – Andres Arango
              Feb 6 at 20:12











            • Thank you for your answer, you are correct in many points im also against the change of the password specialy every day, but the points you and other users give me, will help to stablish a good discussion of the cons and little benefits this could do

              – Andres Arango
              Feb 7 at 1:36

















            If you do the change in SQL Server configuration manager it will inmediately prompt the user the next message "This will cause the service to be restarted. Do you want to continue?"

            – Andres Arango
            Feb 6 at 20:12





            If you do the change in SQL Server configuration manager it will inmediately prompt the user the next message "This will cause the service to be restarted. Do you want to continue?"

            – Andres Arango
            Feb 6 at 20:12













            Thank you for your answer, you are correct in many points im also against the change of the password specialy every day, but the points you and other users give me, will help to stablish a good discussion of the cons and little benefits this could do

            – Andres Arango
            Feb 7 at 1:36





            Thank you for your answer, you are correct in many points im also against the change of the password specialy every day, but the points you and other users give me, will help to stablish a good discussion of the cons and little benefits this could do

            – Andres Arango
            Feb 7 at 1:36











            1















            for security reasons we want to change the password that starts the sql server service everyday




            Why is sql server service restarted everyday ? Just before you restart the service, you can use dbatools - Update-DbaServiceAccount to update the password for the sql server service account.



            e.g. Below Changes the current service account's password of the service MSSQL$MYINSTANCE to 'Qwerty1234'



            $SecurePassword = ConvertTo-SecureString 'Qwerty1234' -AsPlainText -Force
            Update-DbaServiceAccount -ComputerName sql1 -ServiceName 'MSSQL$MYINSTANCE' -SecurePassword $SecurePassword





            share|improve this answer
























            • Interesting I'll check this one

              – Andres Arango
              Feb 7 at 1:37
















            1















            for security reasons we want to change the password that starts the sql server service everyday




            Why is sql server service restarted everyday ? Just before you restart the service, you can use dbatools - Update-DbaServiceAccount to update the password for the sql server service account.



            e.g. Below Changes the current service account's password of the service MSSQL$MYINSTANCE to 'Qwerty1234'



            $SecurePassword = ConvertTo-SecureString 'Qwerty1234' -AsPlainText -Force
            Update-DbaServiceAccount -ComputerName sql1 -ServiceName 'MSSQL$MYINSTANCE' -SecurePassword $SecurePassword





            share|improve this answer
























            • Interesting I'll check this one

              – Andres Arango
              Feb 7 at 1:37














            1












            1








            1








            for security reasons we want to change the password that starts the sql server service everyday




            Why is sql server service restarted everyday ? Just before you restart the service, you can use dbatools - Update-DbaServiceAccount to update the password for the sql server service account.



            e.g. Below Changes the current service account's password of the service MSSQL$MYINSTANCE to 'Qwerty1234'



            $SecurePassword = ConvertTo-SecureString 'Qwerty1234' -AsPlainText -Force
            Update-DbaServiceAccount -ComputerName sql1 -ServiceName 'MSSQL$MYINSTANCE' -SecurePassword $SecurePassword





            share|improve this answer














            for security reasons we want to change the password that starts the sql server service everyday




            Why is sql server service restarted everyday ? Just before you restart the service, you can use dbatools - Update-DbaServiceAccount to update the password for the sql server service account.



            e.g. Below Changes the current service account's password of the service MSSQL$MYINSTANCE to 'Qwerty1234'



            $SecurePassword = ConvertTo-SecureString 'Qwerty1234' -AsPlainText -Force
            Update-DbaServiceAccount -ComputerName sql1 -ServiceName 'MSSQL$MYINSTANCE' -SecurePassword $SecurePassword






            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered Feb 6 at 20:43









            KinKin

            53.7k481190




            53.7k481190













            • Interesting I'll check this one

              – Andres Arango
              Feb 7 at 1:37



















            • Interesting I'll check this one

              – Andres Arango
              Feb 7 at 1:37

















            Interesting I'll check this one

            – Andres Arango
            Feb 7 at 1:37





            Interesting I'll check this one

            – Andres Arango
            Feb 7 at 1:37


















            draft saved

            draft discarded




















































            Thanks for contributing an answer to Database Administrators Stack Exchange!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f229082%2fchange-sql-server-service-account-without-restarting-sql-server%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            Discografia di Klaus Schulze Indice Album in studio | Album dal vivo | Singoli | Antologie | Colonne...

            Lupi Siderali Indice Storia | Organizzazione | La Tredicesima Compagnia | Aspetto | Membri Importanti...

            Armoriale delle famiglie italiane (Car) Indice Armi | Bibliografia | Menu di navigazioneBlasone...