Download SQL SERVER 2008 R2 SP2

Download 32bit SQL Server 2008 R2 SP2

Download 64bit SQL Server 2008 R2 SP2

INSTALLATION STEPS

  1. Right Click in your my computer then Check your computer OS bit method (32 bit or 64 bit)
  2. Download SQL Express 2008 R2 64 bit if your computer in 64 bit from Microsoft Website else Download SQL Express 2008 R2 34 bit if your computer in 34 bit
  3. Double Click on downloaded SQL Server 2008 R2 File. You will  see as belowimage_thumb_1
  4. Setup check your system supported file if computer not support SQL Server install then show as below else go to Next stepimage_thumb
  5. Launch SQL Installer as belowimage12_thumb
  6. Accept License and Terms as belowimage22_thumb
  7. Select all feature of SQL Server as belowimage26_thumb
  8. Type Name of Instance as SQLExpress as belowimage30_thumb
  9. Set Permission as belowimage34_thumb
  10. Set Authentication Mode as belowimage37_thumb
  11. Error Send to SQL Server if you want give YES else NO selection as belowimage40_thumb
  12. Completion of SQL Server Installationimage57_thumb

 

INSTALLATION ISSUES AND SOLVING METHODS

Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.

 

  1. Open SQL Server Configuration Manager. Navigation to Start > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager
  2. Double-click SQL Server (SQLEXPRESS) and change it to use LocalSystem

  3. Delete the folder
    Windows Vista: C:\Users\[user]\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS
    Windows XP: c:\Documents and Settings\[user]\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS