changing sql server service account password

SQL Server 2000 running on W2K3 Advanced Server Cluster with 2 nodes.
We have a domain level account which the MSSQLSERVER and SQLSERVERAGENT
services use.
When I change the password for this account in active directory, I also
changed the password for the services in the Services properties on both
cluster nodes
The services Startup Type has to be Manual, or else the following error
occurs:
"17050: initerrlog: could not open error log file ... (the correct path
to the error log follows)"
The error log is on the shared drive of the cluster.
Also, when the servers boot up, the following error is in Event Viewer:
"The Data portion of event 19002 from MSSQLServer is invalid"
Microsoft (Q230393) says this is a bug and ignore it, but it didn't occur
until I changed the password.
Are these normal consequences of changing the account password?
Are there other steps I should take?
Thanks
Bill
Go back into Enterprise Manager and change the service accounts there. That
will fix any permissions and setup issues. Service startup type as Manual
is correct. That allows the cluster service to control the actual service
start/stop.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"bill" <belgie@.datamti.com> wrote in message
news:uOYfAolLFHA.904@.tk2msftngp13.phx.gbl...
> SQL Server 2000 running on W2K3 Advanced Server Cluster with 2 nodes.
> We have a domain level account which the MSSQLSERVER and SQLSERVERAGENT
> services use.
> When I change the password for this account in active directory, I also
> changed the password for the services in the Services properties on both
> cluster nodes
> The services Startup Type has to be Manual, or else the following error
> occurs:
> "17050: initerrlog: could not open error log file ... (the correct path
> to the error log follows)"
> The error log is on the shared drive of the cluster.
> Also, when the servers boot up, the following error is in Event Viewer:
> "The Data portion of event 19002 from MSSQLServer is invalid"
> Microsoft (Q230393) says this is a bug and ignore it, but it didn't occur
> until I changed the password.
> Are these normal consequences of changing the account password?
> Are there other steps I should take?
> Thanks
> Bill
>
>

Changing IP's on SQL cluster nodes

Hi, I'm having the same problem that was posted earlier this month. In
the thread there was no resolution of how the issue was solved.
Has the issue been solved? If so, how?
Thanks
Couple of articles you may want to read:
http://support.microsoft.com/?id=244980
http://support.microsoft.com/default.aspx?kbid=230356
Not sure what other thread you are talking about.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Jose Lopez-Alvarez" <JoseLopezAlvarez@.discussions.microsoft.com> wrote in
message news:1059CABF-28E2-4690-BDAC-F23B9AC94ED6@.microsoft.com...
> Hi, I'm having the same problem that was posted earlier this month. In
> the thread there was no resolution of how the issue was solved.
> Has the issue been solved? If so, how?
>
> Thanks
|||Hi Rodney, I was refering to the post called "URGENT: Changing IP's on SQL
cluster nodes". I the same situation the author has. There was no solution
posted for his problem.
"Rodney R. Fournier [MVP]" wrote:

> Couple of articles you may want to read:
> http://support.microsoft.com/?id=244980
> http://support.microsoft.com/default.aspx?kbid=230356
> Not sure what other thread you are talking about.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://msmvps.com/clustering - Blog
> "Jose Lopez-Alvarez" <JoseLopezAlvarez@.discussions.microsoft.com> wrote in
> message news:1059CABF-28E2-4690-BDAC-F23B9AC94ED6@.microsoft.com...
>
>

Changing IP of the cluster

Hello!
We will be moving our two cluster running SQL Server 2005 64-bit SP2 on
Windows 2003 to the different datacenter. IP addressed of both nodes will be
changed by DNS names remain the same. I was wondering if anyone had issues
with this. Out thought is that we just need to update IPs in Cluster Manager.
Comments are welcome.
Igor
Here are the instructions from BOL:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/b685f400-cbfe-4c5d-a070-227a1123dae4.htm
The real key is to only change one network at a time and make sure at least
two networks are enabled for private cluster communication. Always give the
cluster a working private communications path so it can settle cluster-wide
changes.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Igor Marchenko" <IgorMarchenko@.discussions.microsoft.com> wrote in message
news:9F4923C9-03A1-400B-B5A8-6183C47F3827@.microsoft.com...
> Hello!
> We will be moving our two cluster running SQL Server 2005 64-bit SP2 on
> Windows 2003 to the different datacenter. IP addressed of both nodes will
> be
> changed by DNS names remain the same. I was wondering if anyone had issues
> with this. Out thought is that we just need to update IPs in Cluster
> Manager.
> Comments are welcome.
> Igor
>
|||Geoff,
Thanks for your reply! For some reason, I am unable to open this link in
BOL. I am getting 'This programn cannot diplay the webpage...' error. Could
you please send me url to BOL online?
Thanks,
Igor
"Geoff N. Hiten" wrote:

> Here are the instructions from BOL:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/b685f400-cbfe-4c5d-a070-227a1123dae4.htm
> The real key is to only change one network at a time and make sure at least
> two networks are enabled for private cluster communication. Always give the
> cluster a working private communications path so it can settle cluster-wide
> changes.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "Igor Marchenko" <IgorMarchenko@.discussions.microsoft.com> wrote in message
> news:9F4923C9-03A1-400B-B5A8-6183C47F3827@.microsoft.com...
>