How to setup SQL Server as pre-requisite?
Follow the following steps to Install SQL Server Setup: o Download SQL Server 2005 Express Edition with Advanced Services SP1 version. http://sourceforge.net/project/showfiles.php?group_id=162339 Installation might not be successful for X64 and IA64 bit machines. o Run the downloaded SQLEXPR.EXE · 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. · Select all compotes in Feature list Dialog. · During its installation, in Authentication Mode Dialog box select Mixed Mode Authenticationand enter password in the specified fields. o After Successful Installation of SQL Server 2005, Go to Start> All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration · Select SQL Server 2005 Surface Area Configuration then · Select Remote Connections under Database Engine then · Select Local and Remote Connections under this step select Using TCP/IP and named pipes
Follow the following steps to Install SQL Server Setup: o Download SQL Server 2005 Express Edition with Advanced Services SP1 version. http://sourceforge.net/project/showfiles.php?group_id=162339 Installation might not be successful for X64 and IA64 bit machines. o Run the downloaded SQLEXPR.EXE • 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. • Select all compotes in Feature list Dialog. • During its installation, in Authentication Mode Dialog box select Mixed Mode Authentication and enter password in the specified fields. o After Successful Installation of SQL Server 2005, Go to Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration • Select SQL Server 2005 Surface Area Configuration then • Select Remote Connections under Database Engine then • Select Local and Remote Connections under this step select Using TCP/IP and named pip