How to - setup SQL Server as pre-requisite
  1. Download SQL Server 2005 Express Edition with Advanced Services SP1 version. Installation might not be successful for X64 and IA64 bit machines
  2. Run the downloaded SQLEXPR.EXE
    1. During this installation, installer will ask you to install Windows Installer 3.1, for this download and install it from URL shown in a message box
    2. Select all compotes in Feature list Dialog
    3. During its installation, in Authentication Mode Dialog box select Mixed Mode Authentication and enter password in the specified fields
  3. After Successful Installation of SQL Server 2005, Go to Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration
    1. Select SQL Server 2005 Surface Area Configuration then
    2. Select Remote Connections under Database Engine then
    3. Select Local and Remote Connections under this step select Using TCP/IP Only then
    4. Run Setup.exe
  4. After successful installation of SQL Server 2005 Start SQL Server Browser service from Administrative Tool Services

Last edited Feb 1, 2008 at 11:26 AM by hardiksa, version 1

Comments

No comments yet.