SQL Server 2000 cannot auto-start

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

SQL Server 2000 cannot auto-start

Author

Topic

sqlteam01
Starting Member

5 Posts

Posted - 2007-11-19 : 10:32:22

I have SQL Server 2000 on a Windows 2003 Sserver, configured as auto-start as when OS starts, using domain account as Startup Service Account. This win2003 is not a domain controller. It worked before but now the SQL 2000 does not start up automatically. If I manually start the SQL server immediately after the OS starts, error 1057 occured. It says "The account name is invalid or does not exist or the password is invalid for the account name specified." Every time, I have to wait for about 10 minutes and then start it successfully.

Any helps will be highly appreciated.

Mark

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-11-19 : 10:47:52

Is the domain account a local admin account on the server also? Try adding it to the local admins and see if this resolves your issue, the problem sounds like it might be a problem with your domain controller applying the GPO's in a timely manner.

Future guru in the making.

sqlteam01
Starting Member

5 Posts

Posted - 2007-11-19 : 11:19:18

Zoroaster, thanks for your prompt reply. The domain account we used is the domain administrator, which is in the local administrators group. I can log in using administrator immediately after OS starts but cannot start SQL server using it. The domain controller is a Win2000 box. If it is a GPO'S applying problem, how can I fix it?

quote:
Originally posted by Zoroaster

Is the domain account a local admin account on the server also? Try adding it to the local admins and see if this resolves your issue, the problem sounds like it might be a problem with your domain controller applying the GPO's in a timely manner.

Future guru in the making.

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-11-19 : 11:30:58

I am not sure, if the account is a local admin then it should be alright there. I am puzzled by the 1057 error since that is indicative of a bad or missing password, it is odd that this would rectify itself after 10 minutes with no changes. If I were you I would turn on security logging on the server and then reproduce the issue and check the security log in event viewer for clues.

Future guru in the making.

sqlteam01
Starting Member

5 Posts

Posted - 2007-11-20 : 11:54:32

I had the event 537 in the security log but don't know if it is related to the problem:

Source: Security
Time: 9:02:34 AM Category: Logon/Logoff
Type: Failure Audi EventID: 537
User: NT AUTHORITY\SYSTEM
Computer: SQLSrvr

Description:
Logon Failure:
Reason: An error occurred during logon
User Name:
Domain:
Logon Type: 3
Logon Process: Authz
Authentication Package: Kerberos
Workstation Name: SQLSrvr
Status code: 0xC000040A
Substatus code: 0x0
Caller User Name: SQLSrvr$
Caller Domain: DomainName
Caller Logon ID: (0x0,0x3E7)
Caller Process ID: 844
Transited Services: -

In the system log: I had EventID: 7000
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.

Until Event 7035:
The MSSQLSERVER service was successfully sent a start control.
The SQL server starts ok.

quote:
Originally posted by Zoroaster

I am not sure, if the account is a local admin then it should be alright there. I am puzzled by the 1057 error since that is indicative of a bad or missing password, it is odd that this would rectify itself after 10 minutes with no changes. If I were you I would turn on security logging on the server and then reproduce the issue and check the security log in event viewer for clues.

Future guru in the making.

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-11-20 : 11:59:08

Is your domain controller running Windows 2000? Have you checked time syncs between your domain controller and the member server?

Future guru in the making.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-11-22 : 17:15:45

Sounds sql server can't verify account to domain controller, checked with your win admin?

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2007-11-23 : 03:15:34