The Application Server Database is a database that runs on Microsoft's SQL Server. Therefore to install the Application Server Database you first have to have a running instance of Microsoft SQL Server. For instruction on how to install SQL Server please refer to the original Microsoft documentation.
Table 1 lists the SQL Server Versions suitable for installing the Application Server Database.
Version |
Version No. |
Notes |
SQL Server 2008 R2 Service Pack 2 |
10.50.40000.0 |
Supported editions: Express, Standard, Enterprise, Datacenter, Workgroup. Unsupported editions: Compact Both, x64 and x86 Versions are supported |
SQL Server 2012 Service Pack 1 |
11.00.3000.00 |
Supported editions: Express, Standard, Enterprise, Workgroup. Unsupported editions: Compact, LightDB Both, x64 and x86 Versions are supported |
SQL Serer 2014 (RTM, SP1, or SP2) |
RTM: 12.00.2000.8 SP1: 12.0.4100.1 SP2: 12.0.5000.0 |
Supported editions: Express, Standard, business Intelligence, Enterprise Both, x64 and x86 Versions are supported |
Table 1: Versions of Microsoft SQL Server suitable for installing the Application Server Database
The Express editions of SQL Server have limits that will influence the overall performance of Redbex. Therefore even though Redbex does support the Express Editions these editions might limit the performance and capabilities of your Redbex installation.
Whatever SQL Server version you are using make sure that you have the latest Service Packs for this version installed. To administrate the Database (e.g. add users, change privileges etc) you should also install Microsoft's SQL Server Management Studio (Express) or a similar database management software.
To determine the version of an installed Microsoft SQL Server you can use your favorite database management software (e.g. Microsoft's SQL Server Management Studio) or run the query shown in listing 1 when connected to that database server.
Select @@version |
Listing 1: SQL query to determine the version of the database server.
