SQL 2005 Won't start unless installed as local system

Question

SQL 2005 Won't start unless installed as local system

yuemo

Mr or Mrs. 500

Points: 526
More actions
November 6, 2007 at 9:57 am

#200229

Hi,
I am trying to install SQL Server 2005 standard edition 32bit on a computer with Server 2003 standard edition/sp2. The processor is AMD athlon 64 FX-62 dual.
The service will not start by using a local account or a domain account. It only starts if installed as local system. The error message is typical:
----
Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (1067) The process terminated unexpectedly.
----
By doing search, two possible issues came out:
1. Processor. But this only mentioned K6.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=324158&SiteID=1
2. Protect folder permission. This folder does not exist, adding does not make any differences.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=845476&SiteID=1
The processor might not be an issue. Because installed as local system runs fine. (Why I want to change? I want to mirror, a domain account make much easier.)
The permission issue sounds great. But no fix.
Any other idea? I appreciate it very much.
-Yuemo

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Vidhya Sagar SSCrazy Eights Points: 8216 More actions · Answer 1

Hi,

You said you can install in Local system account. Then install SQL in Local system account, because service account can be changed later using SQL server configuration manager.

Before changing service account make sure you have given necessary folder and registry privileges. Refer the below link

http://support.microsoft.com/kb/283811

Regards..Vidhya Sagar
SQL-Articles

yuemo Mr or Mrs. 500 Points: 526 More actions · Answer 2

Thanks for the link, I will look for details. http://support.microsoft.com/kb/283811.

This afternoon, I did more work. The problem seems in sp2.

I have to install as local system to start the service. After that I could change the service account. Then if I apply sp2, the service will not start any more. I can put sp1 though. Also only database engine is affected, other services' account can be changed.

So far this works for me: install database engine run by local system, then change the service account as a domain account, then apply sp1.

I will stop on sp1 now, dare not try if sp2 on top sp1 works.

-Yuemo

Vidhya Sagar SSCrazy Eights Points: 8216 More actions · Answer 3

You said after applying SP2 the service account for Database engine changes to local system. Have you tried once againg chaning it to Local account?? IF yes what is the error you are getting while starting up sql services??

Regards..Vidhya Sagar
SQL-Articles

yuemo Mr or Mrs. 500 Points: 526 More actions · Answer 4

Sorry, I may not explain it clearly. Here are the routes I tried.

1. Use domain account to run db engine service, the service will not start. So installation can not continue.

2. Use local system to run db engine service, installation goes fine. SP2 applying goes fine. However when I tried to change the service account to a domain account, the service will not start.

3. Use local user account to run db engine service, the service will not start. So installation can not continue.

4. User local system to run db engine service, installation goes fine. Changing to domain account works. However, if I apply sp2, the service will not start.

In all these cases, the error message is the same as listed in the first post.

Currently the working route is like this: use local system account to run db engine service during installation, then change to a domain account, and apply sp1. Stop here. Did not try any further. Also did not try local account this time.

Thanks,

-Yueo