Instructions Overview – Book in LOL “Installing SQL server Express 2008”
Note: SQL server Express is only compatible with SiteScan Web 4.0 or greater; it will not work with SiteScan Web 3.0 or lower.
Step 1: Download and install Microsoft .Net Framework 3.5 SP1
Step 2: Download and install Windows Installer 4.5
Step 3: Download and install SQL Server 2008 Express
Step 4: Replicate Database to SQL Express in SiteBuilder 4.0
Note: You must have administrative rights on the computer to install and configure SQL Server 2008 Express.
Note: It is possible to have MSDE and SQL Express 2008 running on the same computer. It is recommended that you install and configure MSDE first. During the install of SQL 2008 Express the MSDE system service must be stopped (use the system tray icon) or you will get an error in the SQL Express 2008 installer referring to being unable to modify existing SQL registry keys. If this happens you can stop MSDE and recheck this step in the SQL Express installer, it should pass after MSDE is stopped.
Note: The files contained on SharePoint are redistributable packages meaning you do NOT need an internet connection to complete their install.
Note: System Requirements for Microsoft SQL Express 2008
• Supported Operating Systems: Windows Server 2003 Service Pack 2, Windows Server 2008, Windows Vista, Windows XP Service Pack 2
• Physical Limitations: 1 CPU, 1 GB Memory, 4 GB of user data per database
Instructions Details – Four pages inside above book
Details: Microsoft .Net Framework 3.5 SP1 – one page in LOL
Download and install dotnetfx35.exe
There are no install options other than accepting the license agreement
Note: The installer mentions a download being complete, this is normal and there is no download from the internet required.
Note: If you are prompted a Windows system restart may be required, do not continue until you have restarted the computer.
Details: Windows Installer 4.5 – one page in LOL
Download and install the file that is appropriate for your operating system version and platform.
• For Windows Vista, Windows Vista Service Pack 1 and Windows Server 2008:
o x86 Platform: Windows6.0-KB942288-v2-x86.msu
• For Windows XP Service Pack 2 and Windows XP Service Pack 3 (32-bit platforms):
o x86 Platform: WindowsXP-KB942288-v3-x86.exe
• For Windows Server 2003 Service Pack 1, Windows Server 2003 Service Pack 2 and Windows XP 64-bit Editions:
o x86 Platform: WindowsServer2003-KB942288-v4-x86.exe
There are no install options other than accepting the license agreement
Note: If you are prompted a Windows system restart may be required, do not continue until you have restarted the computer.
Details SQL Server 2008 Express – one page in LOL
Download and install SQLEXPR32_x86_ENU.exe and follow the options detailed below to configure the installation.
Click the Installation button
pic1
Click the new SQL Server stand-alone installation
pic2
On the new pop up window Setup Support Rules you can click the show details button and verify that all steps passed successfully.
pic3
On the product key window verify free version is shown and click next
pic4
Accept the license agreement click next and click the install button. When done click the show details button and confirm that all steps were completed successfully.
pic5
Note: It is possible to have MSDE and SQL Express 2008 running on the same computer. It is recommended that you install and configure MSDE first. During the install of SQL 2008 Express the MSDE system service must be stopped (use the system tray icon) or you will get an error in the SQL Express 2008 installer referring to being unable to modify existing SQL registry keys. If this happens you can stop MSDE and recheck this step in the SQL Express installer, it should pass after MSDE is stopped. You can recheck this step by clicking the Re-run button.
On the feature selection window select all and click next
pic6
On the Instance configuration keep the defaults and for the named instance type SQLExpress. Click next.
Pic7
For Disk space requirements keep all defaults and click next.
Pic 7.5
On the Server Configuration you may have to select and provide a password for the Windows administrator account on the computer, click next
pic8
On the Database Engine Configuration select windows authentication and add current user.
pic9
On Error and Usage Reporting accept the defaults and click next
Pic 9p5
On the Installation Rules click show details and check that all steps passed and click next
pic10
On Ready to Install click the install button, the installation will continue for some time and when done you should have this screen below. Check to see if all steps completed successfully. Click next.
pic11
On the Complete screen verify that the installation completed successfully and click close.
pic12
Note: A windows system restart will be required, do not continue until you have restarted the computer.
Note: when the computer restarts you will not have the typical system tray icon that you might be familiar with for MSDE or SQL2005 SQL2000, this is normal.
Details: SiteBuilder 4.0 configuration – one page in LOL
Instructions here for replication to SQL Express in SiteBuilder 4.0.
Reminder for documentation: update the backup section with a new page for SQL Express backups
