Hi folks,
Can anyone help me out with this strange problem I'm having. I have a
new server (Win 2003 standard) that is part of a domain and it is
running SQL 2000. I have changed the services to run as a domain
account. The password for this account is correct and the account is
also local admin and domain admin.
I am able to manually start the SQL server and SQL agent service
manually but when i restart the box or try to restart the services
they do not start up. I get the following error message in in the
event log:
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7000
Date: 10/05/2007
Time: 09:58:45
User: N/A
Computer: xxxxx
Description:
The MSSQLSERVER service failed to start due to the following error:
The account name is invalid or does not exist, or the password is
invalid for the account name specified.
I checked the account details and they are working as I am able to log
into the server using the account.
Does anyone know why this happens and how i can get SQL and SQL agent
to start up automatically as I don't want to be caught out in the
event of the server rebooting.
Anyone any tips or suggestions?
Thanks in advanceFox1977
The Windows Account for the MSSQLServer service and the SQLServerAgent
service has a bad password, or could not be validated through your Active
Directory or because network services were unavailable.
Do you have any other service that starts under the same account? If so do
you have the same problem with that service also? Also please check the
event logs to check if there are any error messages or warning messages
related to this account. Also one other thing you can try is to use a
different account as a startup for SQL server and see if you can repro the
behavior.
"Fox1977" <foxj77@.gmail.com> wrote in message
news:1178789826.884648.294580@.w5g2000hsg.googlegroups.com...
> Hi folks,
> Can anyone help me out with this strange problem I'm having. I have a
> new server (Win 2003 standard) that is part of a domain and it is
> running SQL 2000. I have changed the services to run as a domain
> account. The password for this account is correct and the account is
> also local admin and domain admin.
> I am able to manually start the SQL server and SQL agent service
> manually but when i restart the box or try to restart the services
> they do not start up. I get the following error message in in the
> event log:
> Event Type: Error
> Event Source: Service Control Manager
> Event Category: None
> Event ID: 7000
> Date: 10/05/2007
> Time: 09:58:45
> User: N/A
> Computer: xxxxx
> Description:
> The MSSQLSERVER service failed to start due to the following error:
> The account name is invalid or does not exist, or the password is
> invalid for the account name specified.
> I checked the account details and they are working as I am able to log
> into the server using the account.
> Does anyone know why this happens and how i can get SQL and SQL agent
> to start up automatically as I don't want to be caught out in the
> event of the server rebooting.
> Anyone any tips or suggestions?
> Thanks in advance
>|||I was getting a netlogon error in the event log saying could not
contact PDC. After doing a bit of searching on the net I came across
this site:
http://www.eventid.net/display.asp?...phase=
1
About half way down there is an entry about lmhosts/wins. I compare
the LMHOSTS setting on the server against some of the other database
servers in the domain. I changed the LMHOSTS/NETBIOS setting to
Default from Disable NETBIOS over TCP/IP.
I rebooted the server and then the PDC error disappeared and the
services started automatically. Brilliant
Thanks for your help, much appreciated
No comments:
Post a Comment