Re: Problem: Changing the SQL Server services password

1) Yes
2) Yes
3) No
4) I get connected to (local) not (SQL2005), I've tried both
5 & 6) sent

Thank you for your help!



""Charles Wang [MSFT]"" <changliw@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:lRCttyQ1JHA.2060@xxxxxxxxxxxxxxxxxxxxxxxxx
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.
====================================================



.

Relevant Pages

  • RE: Sp_xp_cmdshell_proxy_account & SQL 2005
    ... I Iunderstand that you are unable to create the proxy account on SQL Server ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.security)
  • Re: logon failure
    ... MSSQLServer service after you change the username of administrator account. ... username for the SQL Server startup service account or the SQL Server Agent ... Microsoft SQL Server service account on the SQL Server host computer. ...
    (microsoft.public.windows.server.sbs)
  • RE: Problem: Changing the SQL Server services password
    ... Are the passwords of SQL Server service account and Microsoft Cluster ... By default the error logs are located in the folder ...
    (microsoft.public.sqlserver.clustering)
  • RE: Impersonation, Delegation & SQL Server
    ... After setting windows integrated authentication method in IIS and specify the impersonation to true for asp.net application, ... your asp.net application will run with the security of UserA account. ... Then when you access SQL server database, ... You can obtain it free of charge from Microsoft. ...
    (microsoft.public.inetserver.iis.security)
  • RE: Dump file
    ... "short stack dump" that is present in the error logs. ... Vikram Jayaram ... Microsoft, SQL Server ...
    (microsoft.public.sqlserver.server)
Quantcast