RE: Problem: Changing the SQL Server services password
- From: changliw@xxxxxxxxxxxxxxxxxxxx ("Charles Wang [MSFT]")
- Date: Fri, 15 May 2009 03:24:26 GMT
Hi Frank,
Welcome to Microsoft TechNet Managed Newsgroup Services.
To let me better understand this scenario and perform effective research, I
appreciate it if you could first answer me some questions and help collect
the requested information as following:
1. Did you verify if the failover function worked fine before you tried to
change the password?
2. Can your SQL Server cluster work fine if you change the password back to
the original?
3. Are the passwords of SQL Server service account and Microsoft Cluster
Service (MSCS) account same?
If they are same, I recommend that you change them to different. Use a
domain administrator account to your MSCS, and a different domain user
account for your SQL Server service.
4. What is the result if you do not use command line to run the SQL Server
Configuration Manager?
5. SQL Error Logs
By default the error logs are located in the folder
%ProgramFiles%\Microsoft SQL Server\MSSQL(.N)\MSSQL\LOG. For SQL Server
cluster, the error logs are located in your cluster share folder.
6. Windows Event Logs on both your active node and passive node
Please gather Windows Event Logs on the problematic node:
Start -> Administrative Tools -> Event Viewer -> Export application/system
event logs with both EVT & TXT format and send them to me.
Since the files may be larger than 2MB, I recommend that you first send me
(changliw_at_microsoft_dot_com) an email response. Then I will send an
email response to you and let you know how to upload the files to me.
Thank you!
Best regards,
Charles Wang
Microsoft Online Community Support
Get Secure! - www.microsoft.com/security
====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
====================================================
.
- Follow-Ups:
- References:
- Problem: Changing the SQL Server services password
- From: frankm
- Problem: Changing the SQL Server services password
- Prev by Date: Problem: Changing the SQL Server services password
- Next by Date: Re: Problem: Changing the SQL Server services password
- Previous by thread: Problem: Changing the SQL Server services password
- Next by thread: Re: Problem: Changing the SQL Server services password
- Index(es):
Relevant Pages
|
