|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
| ms.sqlserver.setup Questions about SQL Server. |
 |
|
|
LinkBack | Outils de la discussion |
24/10/2007, 16h46
|
#1 |
Messages: n/a
Hébergeur: |
Resetting password for sql services domain accounts
I need to reset the password of the domain account sql services are running
under. Is there any known issue I should be aware of ? Should I restart the services after resetting the paswword? Any would be appreciated. Carlos |
|
|
26/10/2007, 12h59
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: Resetting password for sql services domain accounts
Carlos wrote:
> I need to reset the password of the domain account sql services are running > under. Is there any known issue I should be aware of ? Should I restart the > services after resetting the paswword? > > Any would be appreciated. > > Carlos Hello Be careful  1st) Change password first on on the domain controller 2nd) In the Services snap-in in the MMC, right-click the SQL Server (MSSQLSERVER) service and then click Properties and on the Logon tab, type the new password in the Password and Confirm password boxes To save the changes, you must restart the SQL Server service. This will cause the services that the SQL Server service provided to be momentary unavailable while the SQL Server service restarts. You should not change the passwords for any of the SQL Server service accounts when a failover cluster node fails or is offline. If you have to do this, you will need to reset the password again by using Configuration Manager when all nodes are back online. regards SW |
|
|
|
26/10/2007, 12h59
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: Resetting password for sql services domain accounts
Carlos wrote:
> I need to reset the password of the domain account sql services are running > under. Is there any known issue I should be aware of ? Should I restart the > services after resetting the paswword? > > Any would be appreciated. > > Carlos Hello Be careful 1st) Change password first on on the domain controller 2nd) In the Services snap-in in the MMC, right-click the SQL Server (MSSQLSERVER) service and then click Properties and on the Logon tab, type the new password in the Password and Confirm password boxes To save the changes, you must restart the SQL Server service. This will cause the services that the SQL Server service provided to be momentary unavailable while the SQL Server service restarts. You should not change the passwords for any of the SQL Server service accounts when a failover cluster node fails or is offline. If you have to do this, you will need to reset the password again by using Configuration Manager when all nodes are back online. regards SW |
|
|
|
| Outils de la discussion | |
|
|
