Installing SQL Server 2005 Express Edition

1)        Make sure you have the latest Windows Installer 3.1 installed on your server. This is required to install all editions of SQL Server 2005. If you do not have it you can download it using the link below.

http://www.comtechsolutions.com/microsoft/WindowsInstaller3.1.exe

2)        Download SQL Server 2005 Express Edition from Microsoft’s web site using the link below. Select the SQL Server 2005 Express Edition with Advanced Services (234MB) which includes SQL Server Management Studio Express, a graphical management tool based on SQL Server Management Studio that makes it easy to manage and administer SQL Server Express databases.

http://msdn.microsoft.com/vstudio/express/sql/download/

3)        Run the file SQLEXPR_ADV.EXE and follow the steps below to configure it to work properly with VisionCore.

4)        Accept the License Agreement and click Next

5)        Click Install to install the prerequisites

6)        Click Next to start installing SQL Server 2005

7)        After the System Configuration Check completes click the Next button

8)        Enter your name and Company and deselect the Hide advanced configuration options, then click Next to continue.

9)        In the Feature Selection Enable the Management Studio Express option and click Next

10)        Select Named Instance and type in the name VisionCore as your unique instance. You can enter any name you wish here but you should give it a name that you will remember and corresponds to VisionCore.

11)        Leave the default options in the Service Account form and click Next

12)        Select Mixed Mode and enter a unique Password for the sa (System Administrator) account

13) Leave the default options and click the Next button to continue.

14)        Select Enable User Instances and click Next

15)        Leave the default options and click Next to continue

16)        Click Install to begin installing SQL Server 2005 Express Edition

17)        After all the components have been installed click Next to continue

18)        Click Finish to complete the installation

19)        This completes the installation of SQL Server 2005 Express Edition. Next you need to enable a couple of settings to allow SQL Server 2005 to work over your network.

20)        From the Start menu select Microsoft SQL Server 2005 | Configuration Tools | SQL Server Configuration Manager.

21)        Under SQL Server 2005 Network Configuration select Protocols for VISIONCORE and Enable the following:

Shared Memory

Named Pipes

TCP/IP

22)        You will see a warning message box saying you need to stop and restart the service.

23)        To Stop the service select SQL Server 2005 Services and then select SQL Server (VISIONCORE). Then click the Stop button to stop running SQL Server (VISIONCORE).

24)        After the service has stopped you can click the Start button to start SQL Server (VISIONCORE) again.

25)        Select SQL Server Browser and click the Start button. If you cannot start the browser from here follow the next few steps.

26)        On the Start menu, right-click My Computer, and then click Manage. In Computer Management, expand Services and Applications, and then click Services. Right click on SQL Server Browser and select Properties.

27) In the SQL Server Browser Properties window change Startup Type to Automatic and click the Start button to start the service.

28) Now back in the SQL Server Configuration Manager both the SQL Server (VISIONCORE) and SQL Server Browser should be running.

29)        Next make sure your Firewall is configured to allow files to be shared. If you are using the Windows XP built in Firewall open the Windows Control Panel select Windows Firewall and under the Exceptions tab make sure File and Printer Sharing is enabled

 Now you should Reboot your server.