Re: Changed Windows password breaks SQL Server access

From: Richard Waymire [MS] (rwaymi_ms@microsoft.com)
Date: 07/16/02 

From: "Richard Waymire [MS]" <rwaymi_ms@microsoft.com>
Date: Tue, 16 Jul 2002 10:47:05 -0700

Also note that in particular if this is a cluster you should change hte
password in Enterprise Manager so it can sync the passwords up on all nodes
of the cluster. 

--
Richard Waymire, MCSE, MCDBA
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kerry Calvert" <calvertk@tce.com> wrote in message
news:1876f01c22ce2$0bfaebe0$b1e62ecf@tkmsftngxa04...
> I found out how to solve the problem, so I am posting the
> answer to my own question.
>
> Go into My Computer/manage, and select the properties on
> the MSSQL$(database instance) service entry. Go to the log
> on tab, and reset the password of the user used to start
> the server.  I am going to change this user to be a local
> account on the server's system so that this does not
> happen in the future (we are required to change domain
> passwords every month)
>
> >-----Original Message-----
> >I am running SQL Server 2000, and have set the connection
> >to use Windows authentication.  When I changed my
> password
> >on the Windows domain, I can no longer start up SQL
> Server.
> >
> >Setting my windows password back to what it was when I
> >could access SQL server does not work either.
> >
> >I can't log on to the server using the sa account under
> >SQL Server authentication either, since either I forgot
> >that I assigned a password to SA, or it won't take an
> >empty password.  I am pretty sure I never assigned a
> >password to sa.
> >
> >Is there anything I can do short of re-installing SQL
> >Server ?
> >.
> >

Relevant Pages

  • Re: How to cluster sql in a 2003 cluster
    ... For the most part setup on a Windows 2003 cluster is identical to setup on ... SQL Server 2000 does not support mount points. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Upgrading Windows 2000 cluster to Windows 2003 Cluster.
    ... I made absolutely sure I had all the drivers and software for Windows ... worked as a cluster host node, I upgraded its peer node, also in-place. ... You must re-run any service packs and hotfixes after the install when you ... SQL server 2000 which we installed it as a virtual server. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Rolling Upgrade of SQL2000/W2000 cluster to SQL2000/W2003
    ... Could someone out there please point me to a good guide to complete a rolling upgrade of a Windows 2000 SQL Server 2000 2 node cluster to Windows 2003 SQL Server 2000 cluster? ...
    (microsoft.public.sqlserver.server)
  • Re: Upgrading Windows 2000 cluster to Windows 2003 Cluster.
    ... The SQL binaries and cluster configuration survived the upgrade. ... Microsoft SQL Server MVP ... I then upgraded one node in-place to Windows 2003. ... You must re-run any service packs and hotfixes after the install when you ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL2000 Cluster on Windows 2003 SP1 Cluster
    ... There is one special work-around for installing a named instance on a ... Windows 2003 cluster. ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)