Wednesday, March 28, 2012

Microsoft SQL server 2000 can't stand up after change administrator password?!?!

HI!
I have a little problem:
I have change the administrator password (Windows 2003 Server) which MS
SQL 2000 use to login.
And now the SQL server can't stand up.
What should I do?
thx!
gicio
--
Posted via http://dbforums.comGicio,
In control panel | services applet, change the password for the sqlserver
service logon account.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"gicio" <member21186@.dbforums.com> wrote in message
news:3198256.1060001631@.dbforums.com...
> HI!
> I have a little problem:
> I have change the administrator password (Windows 2003 Server) which MS
> SQL 2000 use to login.
> And now the SQL server can't stand up.
> What should I do?
> thx!
>
> gicio
> --
> Posted via http://dbforums.com|||>--Original Message--
{snip}
>I have change the administrator password (Windows 2003
Server) which MS
>SQL 2000 use to login.
>And now the SQL server can't stand up.
>What should I do?
>
{SNIP}
Update the login information (the password) in the
services. The services are still trying to use the old
password.
Consider using a separate account for running SQL server
and SQL Server Agent. Plan on updating the password in
services as well when you change the service account
password.

No comments:

Post a Comment