When attempting to install ACT! you receive one or both of the following error messages: "29503 The SQL Server service failed to start." or "SQL Express Install fails Error 29503 / 1067" When Attempting to install Act!.
$obsdisclaimer This can result if you are missing the following Windows® Registry Key:
Important: If you cancelled the installation when you received the error, then you must manually remove the ACT! instance of SQL before proceeding to the next steps. The following Knowledgebase article provides instructions for manually removing the ACT! instance of SQL:
Answer ID: How to Manually Remove the ACT7 Instance of SQL Server 2005®
If you did not cancel the installation and the error dialog box is still up, then follow the steps below to create the needed registry key, and then click Retry in the error dialog box to continue the installation.
Creating the Domain registry key
To create this key, use the following steps:
- Click the Windows Start button, and then click Run. The Run dialog box appears.
- Type regedit in the Open field, and then click OK. The Windows Registry Editor launches.
Caution: We strongly recommend that you back up the system registry before making any changes. Incorrect changes to the registry could result in permanent data loss or corrupted files. Please make sure you modify only the keys specified. For detailed information on backing up the Windows Registry, click the link below:
Title: How to Back Up the Windows Registry
Answer ID: How to back up the Windows Registry
- In the left pane click the plus sign next to Computer to expand.
- Click the plus sign next to HEY_LOCAL_MACHINE to expand.
- Click the plus sign next to SYSTEM to expand.
- Click the plus sign next to CurrentControlSet to expand.
- Click the plus sign next to Services to expand.
- Click the plus sign next to Tcpip to expand.
- Right-click Parameter, point to New, and then click Key.
- Name the Key Domain.
- Close the Windows Registry Editor, and install ACT!.
Another possible cause for this error is that the SQL Server service is not set to log on under the Local System account. Follow these steps to verify and correct if needed:
- From your Windows Start menu, select Run, and type services.msc in the Open box. Windows Vista users will just type this command in the Search box on the Start menu.
- When the list of local services appears, scroll down and locate SQL Server (ACT7).
- Right-click on this service and select Properties. On the Properties screen, click the Log On tab.
- Under "Log on as", ensure that Local System account is selected. If not, then select it, click Apply, then click OK.
- Right-click on the SQL Server (ACT7) service again and select Restart so that the change will take effect.
Install using Built-in Administrator Account (Windows 10 Only)
If you are using Windows 10, you maybe be able to work around this issue by enabling the Built-in Administrator user account and then reattempting the installation. For more information on enabling this account, please refer to the following information:
How To Enable the Built-In Administrator Account in Windows 10
Answer ID: How To Enable the Built-In Administrator Account in Windows 10
Manually Install SQL Server (ACT7) Instance using 'Network Service' Option.
You may be able to work around this issue by installing the Act7 instance manually and selecting 'Network Service' instead of 'Local Service'. Once the Act7 instance is successfully installed you must open the Windows Services screen (using Windows Start button > select Run or use Search field > enter 'Services.msc') and manually change the properties for 'SQL Server (ACT7)' to 'Local Service' and restart the service. For more information on manually installing the Act7 instance for Microsoft SQL Server 2005 Express, please refer to the following article:
How to Manually Create the Microsoft® SQL Server® 2005 (Express Edition) ACT7 Instance
Answer ID: How to Manually Create the Microsoft® SQL Server® 2005 (Express Edition) ACT7 Instance
Multiple Network Cards
This issue has been reported to occur if the Network Interface Card (NIC) is configured with multiple IP addresses. For more information on this, please refer to the following Microsoft article: SQL Server fails to start if NIC has multiple IP address
For more information on this, please refer to the following Microsoft article: On a computer that has a multicore processor, if the ratio of logical processors to physical sockets is not a power of 2, you cannot install SQL Server 2005