SQL

SQL 2005 Installation:

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 & conditionsScreenHunter_4 ScreenHunter_5ScreenHunter_6 ScreenHunter_8Step 3:Fill the registration information.ScreenHunter_9  Step 4:According to SQL 2005 guide we need to select below option to implement SAP in it.ScreenHunter_10 ScreenHunter_11  Step 5:User Name must be SIDADM and provide strong password for your SQL DB.ScreenHunter_131  And provide password for mixed mode authentication.  ScreenHunter_141  Step 6:Just follow the SQL 2005 guide and set the below Collation settingsScreenHunter_15 ScreenHunter_16 ScreenHunter_17 ScreenHunter_18  Step 7:SAP recommendation, DB installation should be in J drive, and follow the guide and make the below changes.ScreenHunter_19 ScreenHunter_20 ScreenHunter_21  Step 8: Finally we have successfully installed SQL 2005 in required server. PFBScreenHunter_26 ScreenHunter_27  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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s