Changing SQL Server Service Credentials

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello,

I am trying to automate a periodical change of the Sql server service
account credentials. I am performing the following steps:

1. Change password in the domain
2. Change service credentials (logon information in the services MMC)

Is it mandatory to restart the SQL Server? As SQL server is already
connected and authenticated, will it continue to operate normally
after the password change?
When does the sql server read the credentials from the service info,
does it re-logon? if yes, can I somehow dynamically update the
credentials without restarting the service?


Thanks,
Yael.
.

Relevant Pages

  • Re: Balancing security needs in ADO.NET applications
    ... See my article http://www.developer.com/db/article.php/3693236 that shows how to put together a hierarchical TableAdapter using SPs. ... Hitchhiker's Guide to Visual Studio and SQL Server ... SQL Server credentials or the application's logon/pw. ... all they can do is run specific SPs that carefully guard the data and do not permit gross operations like dropping tables or changing rights. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Changing SQL Server Service Credentials
    ... Change password in the domain ... Change service credentials ... Is it mandatory to restart the SQL Server? ...
    (microsoft.public.sqlserver.server)
  • Re: Login failed for user . The user is not associated with a trusted SQL Server connection.
    ... he never mentioned he is impersonating in asp.net - so no delegation needed. ... Cassini runs with the credentials of the interactive user - which seems to have access to sql - in contrast to the local ASPNET account - which i am trying to tell him since 2 days.... ... yes - use explicit credentials and enable mixed mode auth in sql server to get this to work. ...
    (microsoft.public.dotnet.security)
  • Re: Balancing security needs in ADO.NET applications
    ... you can't control security at this level) user access is determined by their ... SQL Server credentials or the application's logon/pw. ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: IIS 6 and SQL Server - two seperate boxes
    ... make use of a risky solution. ... login to your SQL Server is that exploiting a "known vulnerability"? ... And the credentials could be stolen on ... the server (e.g. from a web.config file if you are using a static account), ...
    (microsoft.public.inetserver.iis.security)