sql service password in cluster changed by wrong method

Hi,
We have an 2-node Active/Active SQL 2000 SP3a cluster on Windows 2003.
Accordingly we have 2 instances of SQL, INST1 on node 1 and INST2 on node2.

I think our db admin did a "no no" a few weeks back. Having an issue with
something SQL related, she changed the MSSQL$INST2 service account logon
password on Node 2 from a domain user account to Local System using the
Services applet. Then she changed it back to the domain user account using
the Services applet. Now, both instances on each node really only work on
their respective node. Failover doesn't always work, and IF it does, not
everything seems to work correctly (i.e., she said replication does not
always work). If I get both to fail to one node, one of the instances will
start as Local System and the other as the domain user account. I don't
think this is correct.

So, being told this, I did some research and password changes are supposed
to be done within the SQL Enterprise Manager. So went to change the Startup
Service Account through the SQL EM, tried to change the password and we get
the following error:


Microsoft SQL-DMO (ODBC SQLState: 42000)
----------------------------------------
Error 22042: xp_SetSQLSecurity() returned error -2147024893, 'The system
cannot find the path specified."


I know I didn't give much info on the exact problems we have with SQL now, I
need to wait until next downtime to test some more, but I need to know how
bad it was to change the password in that manner and possible resolution.
Thank you.


.

Relevant Pages

  • Login failed for user sa.
    ... Changed the service account from local system ... to a Domain user account using Enterprise Manager. ... Everything worked fine and all databases are accessible. ... SBS2000 box running all service packs including SQL SP3 ...
    (microsoft.public.sqlserver.security)
  • Re: Change the domain setting for the MS SQL 2000 Server
    ... The reason why I did not post that solution is that SQL ... service account using ... I can set the service setting to use ... >> or to use a domain user account. ...
    (microsoft.public.sqlserver.server)
  • RE: Domain or Local User Account for Laptop SQL 2008 Services
    ... I think I'd like to use a Domain User Account for the SQL 2008 services, but if I do this, will SQL Server function properly when I'm not connected to my network? ... SQL Server will try to connect to your domain controller for establishing authentication at startup if you configured your SQL Server service to a domain user account. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.setup)
  • Re: SPN creation
    ... will i need to create an spn for the live sql server service account in order ... front end website to get Kerb delegation to the backend if your AD is 2003 ... form port-specific SPNs for HTTP, ...
    (microsoft.public.windows.server.active_directory)
  • Re: SPN for SSL over common name
    ... you can't register those SPNs under the SQL Server's ... service account is the MSSQL SPN. ... That SPN should be registered under ... Lastly, since the SQL Server is not being used for delegation anywhere, ...
    (microsoft.public.inetserver.iis.security)