Installing SQL Server Express 2005

End User License Agreement: click [Next]
instal1

Install any prerequisites: click [Install]

instal2

Welcome, Configuration Check, and Registration Screens: Click [Next]
instal3

Feature Selection Screen: Database Services and Client Components should be set to “Will be installed on local hard drive”. Click [Next].

instal4

Authentication Mode Screen
Since TopView may run under different Windows user accounts, we recommend using Mixed Mode Authentication. You can leave the ‘sa’ password blank (recommended) or enter the password topview and click [Next]. If you decide to enter a different password for ‘sa’, make sure you remember the password since you need this password when you configure SQL Server for use by TopView.

instal5

Configuration Options Screen
TopView does not require User Instances, so this option is not required.
You should “Add user to the SQL Server Administrator role”. Click [Next].

instal6

Error and Usage Report Setting Screen: uncheck items and click [Next]

instal7

Ready to install Screen: click [Install] and complete the installation

instal8

Post-installation steps:

Enable and Start the ‘SQL Server Browser’ Service:
This Service allows applications like TopView to automatically see the SQL Server instances that are available. In order for SQL Server to appear in the SQL Server drop-down in TopView you must enable and start this Service.