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.”

I have fixed the issues according to follow the Microsoft article.

please follow the below steps to fix the issues.

Method 1.

Before you install SQL Server 2005, temporarily change the number of logical processors to one. This makes the computer appear to be a single-processor system, and SQL Server 2005 is installed successfully. To do this, follow these steps:

Windows Server 2003

1. To change the number of logical processors in Windows Server 2003, follow these steps:
   1. Click Start, click Run, type msconfig, and then click OK.
   2. In the System Configuration Utility dialog box, click the BOOT.INI tab.
   3. On the BOOT.INI tab, click Advanced Options.
   4. In the BOOT.INI Advanced Options dialog box, click to select the /NUMPROC= check box.
   5. In the list that is next to the /NUMPROC= check box, click 1, and then click OK.
   6. In the System Configuration Utility dialog box, click OK.
   7. Restart the server.
2. Install SQL Server 2005.
3. Install the latest service pack for SQL Server 2005.

   For more information about how to obtain the latest SQL Server 2005 service pack, click the following article number to view the article in the Microsoft Knowledge Base:

   913089 How to obtain the latest service pack for SQL Server 2005
4. Restart the server by using all the processors. To do this, follow these steps:
   1. Click Start, click Run, type msconfig, and then click OK.
   2. In the System Configuration Utility dialog box, click the General tab.
   3. On the General tab, click Normal Startup – load all device drivers and services, and then click OK.
   4. Restart the server.

SQL 2005 Installation Steps

Prerequisites:

• Download the SQL 2005 Dump into the server.
• Before kickoff the Installation, go through the SQL 2005 guide in sap market place. [server.sap.com]

Installation Steps:

Step 1: Double click on setup.exe file.

Step 2:Click to accept the terms & conditions

 

 

Step 3:Fill the registration information.

 

Step 4:According to SQL 2005 guide we need to select below option to implement SAP in it.

 

 

Step 5:User Name must be SIDADM and provide strong password for your SQL DB.

 

And provide password for mixed mode authentication.

 

 

Step 6:Just follow the SQL 2005 guide and set the below Collation settings

 

 

 

 

Step 7:SAP recommendation, DB installation should be in J drive, and follow the guide and make the below changes.

 

 

 

Step 8: Finally we have successfully installed SQL 2005 in required server. PFB

 

 

I have faced one Major issues during my installation. the SQL service is not coming up while installing, i have fixed as followed by Microsoft articles.

 

WORKAROUND

Method 2

Before you install SQL Server 2005, temporarily change the number of logical processors to one. This makes the computer appear to be a single-processor system, and SQL Server 2005 is installed successfully. To do this, follow these steps:

Windows Server 2003

1. To change the number of logical processors in Windows Server 2003, follow these steps:
   1. Click Start, click Run, type msconfig, and then click OK.
   2. In the System Configuration Utility dialog box, click the BOOT.INI tab.
   3. On the BOOT.INI tab, click Advanced Options.
   4. In the BOOT.INI Advanced Options dialog box, click to select the /NUMPROC= check box.
   5. In the list that is next to the /NUMPROC= check box, click 1, and then click OK.
   6. In the System Configuration Utility dialog box, click OK.
   7. Restart the server.
2. Install SQL Server 2005.
3. Install the latest service pack for SQL Server 2005.

   For more information about how to obtain the latest SQL Server 2005 service pack, click the following article number to view the article in the Microsoft Knowledge Base:

   913089 How to obtain the latest service pack for SQL Server 2005
4. Restart the server by using all the processors. To do this, follow these steps:
   1. Click Start, click Run, type msconfig, and then click OK.
   2. In the System Configuration Utility dialog box, click the General tab.
   3. On the General tab, click Normal Startup – load all device drivers and services, and then click OK.
   4. Restart the server.

Thanks & Regards,

Sabarish Vasudevan.