RE: Problem: Changing the SQL Server services password
- From: changliw@xxxxxxxxxxxxxxxxxxxx ("Charles Wang [MSFT]")
- Date: Fri, 15 May 2009 03:29:04 GMT
Hi Frank,
Thank you for posting here!
I notice that you have posted the same question in our clustering
newsgroup, which I have already responded. So please check my answer there
and if you need any further assistance on this particular issue, please
reply to me in that thread so I can follow up with you in time. Also I
appreciate your understanding that for managed newsgroup services, you will
be guaranteed a response within two business days according to the service
agreement, however usually we will try to give you the response as soon as
possible.
For your convenience, I have included my reply as follows:
------------------
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 and have a nice day!
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.
====================================================
.
- References:
- Problem: Changing the SQL Server services password
- From: frankm
- Problem: Changing the SQL Server services password
- Prev by Date: Re: Distributed Query - Linked Servers?
- Next by Date: Re: Can't run Reports->Standard Reports -> Disk Usage
- Previous by thread: Problem: Changing the SQL Server services password
- Next by thread: SQLServer 2008 Express + SP1
- Index(es):
Relevant Pages
|
