Re: SQL Server wont restart after reboot/reset

#1

Usually when I want to change the service accounts I will do it through EM.
Have you tried doing it through EM and not the Control Panel applet ?

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"steve" <sgent001 (AT) hotmail (DOT) com> wrote

Quote:

I am having a problem with my SQL server. Recently (last
two weeks) when ever we restart the SQL services or
reboot the server the SQL services (MSSQLServer,
SQLServerAgent) wont restart. We get a login failure
message from both services.

Our current solution is to look at the properties for
each service and re-enter the password for the service.
This seems to work but the next time the service is
restarted it fails again.

I heard that SQL was very temperamental about changing
the passwords so we set up a special admin account that
we have never changed since we installed the server last
month.

We are running SQL 2000 sp3a on windows 2003.

Any assistance you can provide will be greatly
appreciated.
Steve

#2

Yes, I have tried to change the account through EM. It
worked the first time the service restarted but didn't
work after that. It is a very odd problem.

This wouldn't even be an issue, but recently we have had
to start restarting the service every 32 hours due to a
programming glitch in one of our applications (They are
trying to fix it as I write this)which locks the server.

Steve

Quote:

-----Original Message-----
Usually when I want to change the service accounts I
will do it through EM.
Have you tried doing it through EM and not the Control
Panel applet ?

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"steve" <sgent001 (AT) hotmail (DOT) com> wrote in message
news:0ac601c34493$fc7604a0$a301280a (AT) phx (DOT) gbl...
I am having a problem with my SQL server. Recently
(last
two weeks) when ever we restart the SQL services or
reboot the server the SQL services (MSSQLServer,
SQLServerAgent) wont restart. We get a login failure
message from both services.

Our current solution is to look at the properties for
each service and re-enter the password for the service.
This seems to work but the next time the service is
restarted it fails again.

I heard that SQL was very temperamental about changing
the passwords so we set up a special admin account that
we have never changed since we installed the server
last
month.

We are running SQL 2000 sp3a on windows 2003.

Any assistance you can provide will be greatly
appreciated.
Steve

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: SQL Server wont restart after reboot/reset

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup

Re: SQL Server wont restart after reboot/reset - 07-07-2003 , 11:03 AM

Re: SQL Server wont restart after reboot/reset - 07-07-2003 , 12:25 PM