Install your MS Database Server
BPC RiskManager Installation Step 1 - Install your MS Database Server
BPC RiskManager V6 (ENrima Edition) supports MSDE 2000, SQL Server 2000, SQL Express 2005 or SQL Server 2005. BPC RiskManager Express V5 supports Interbase, Oracle 10G+, MSDE 2000, SQL Server 2000, SQL Express 2005 or SQL Server 2005. You will need to install one of these database engines on the Database Server Computer.
The database server MUST be installed in sql server security (or mixed security) mode. Ie. The application server and mailmanager components will attempt to access the database server in sql authentication mode, not windows integrated security mode. In SQL Express and SQL Server 2005, windows integrated security mode is the default setting, so you must over-ride this to use Mixed mode/SQL security mode (as well as windows integrated security). If you don’t know what this means, just watch the sql server install wizard as it steps through the configuration steps – you will see the page early in the install process with the windows integrated security option.
When you choose mixed mode authentication, you will be asked to provide a password for the systems administration account (username = sa). In SQL Express and SQL 2005 you MUST enter a password. Make sure you remember it as you will need it later.
With SQL Express (2005), we recommend that your install BOTH the SQL Express 2005 server AND the SQL Server Management Studio. You will need the Management Studio to maintain the databases and possibly to apply updates as well as other tasks.
SQL Express 2005 server & management studio can be downloaded from Microsoft’s web site at this address:
http://www.microsoft.com/express/2005/sql/download/default.aspx
Follow the instructions on the web site. You may need to install the .Net framework Version 2 and the MSXML6 components first (although most current machines have these components already).
The two SQL components you definitely need are:
- Install Microsoft SQL Server 2005 Express Edition
- SQL Server Management Studio Express
