INFO: SQL Server Express
SQL Server Express edition is a free version of SQL Server 2005 and is an excellent choice for use with RMTrack.
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.
- 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
- Download and install SQL Express SP2
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:
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.
Expand SQL Server 2005 Network Configuration, and then click Protocols for InstanceName.
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
Click Start, click Control Panel, and then click Network Connections.
From the navigation bar on the left, click Change Windows Firewall settings.
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:
Click Add Program.
Navigate to drive:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\BINN
Add the file sqlservr.exe to the list of exceptions.
- Click Add Program.
RMTrack Issue Tracking - All versions