INFO: SQL Server Express

Summary

SQL Server Express edition is a free version of SQL Server 2005 and is an excellent choice for use with RMTrack.

Limitations

The free version of SQL Server has several limitations. These limitations will only affect very large RMTrack installations.

• A single database is limited to 4GB.
• Can install and run on multiprocessor machines, but only a single CPU is used at any time.
• The 1 GB RAM limit is the memory limit available for the buffer pool.
• SQL Agent is not included - this disables RMTrack's integrated backup/restore functions. See Teratrax for an add-on job scheduler for backups.

Downloads

1. Download and install the Microsoft .NET Framework 2.0 SP1 either the 32 bit or 64 bit version:
   • Microsoft .NET Framework 2.0 Service Pack 1 (x86) - 32 bit
   • Microsoft .NET Framework 2.0 Service Pack 1 (IA64) - 64 bit
   Note: On Windows Server 2000 SP4, install KB 835732 before installing .NET Framework 2.0 Service Pack 1.
2. Download and install SQL Express SP2
   • Microsoft SQL Server 2005 Express Edition with Advanced Services

Installation Notes

If your are installing SQL Express on the same server as RMTrack then the installation defaults should be fine. When installing RMTrack use ".\SQLEXPRESS" for the server name and use "Windows Integrated Security" for how to log on to the server.

If you are installing SQL Express on a separate server from RMTrack then after then installation completes you will need to enable SQL's TCP/IP network protocol and ensure that the local Windows Firewall (if enabled) has been configured to permit SQL Server connections.

To enable TCP/IP:

1. From the Start menu, select All Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager.

   Optionally, you can open Computer Manager by right-clicking My Computer and selecting Manage. In Computer Management, expand Services and Applications, expand SQL Server Configuration Manager.

2. Expand SQL Server 2005 Network Configuration, and then click Protocols for InstanceName.

3. In the list of protocols, right-click the protocol you want to enable, and then click Enable.

   The icon for the protocol will change to show that the protocol is enabled.

To enable the firewall

1. Click Start, click Control Panel, and then click Network Connections.

2. From the navigation bar on the left, click Change Windows Firewall settings.

3. On the Exceptions tab, in the Programs and Services box, you will probably see that SQL Server is listed, but not selected as an exception. If you select the check box, Windows will open the 1433 port to let in TCP requests. Alternatively, if you do not see SQL Server listed, do the following:

   1. Click Add Program.
      
   2. Click Browse.
      
   3. Navigate to drive:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\BINN
      
   4. Add the file sqlservr.exe to the list of exceptions.
      

Applies to

RMTrack Issue Tracking - All versions

Keywords: Install, SQL, SQL Express