ProMapper Installation Instructions

ProMapper can work with an enterprise SQL Server 2005/2008/2008r2/2012/2014 or a locally installed SQL Server Express of the same versions.

Enterprise SQL Server:

  1. Have your database admin attach the database files ProMapper.mdf and ProMapper.ldf to SQL Server as ProMapper (or other convenient database name). This can be done using SQL Server Management Studio.

SQL Express (local installation)

  1. Download Microsoft SQL Express and SQL Server Management Studio Express (SSMSE) from https://www.microsoft.com/express/Database/ (using the “Database with Management Tools” download link).

  2. Install SQL Server Express using all default options.

  3. Install SQL Server Management Studio Express.

  4. Copy the database files ProMapper.mdf and ProMapper.ldf to a convenient folder with at least a few GB of free space. The space required depends on the size of the application files.

  5. Run SQL Server Management Studio Express. You will be prompted to connect to a server. Select (local)/SQLExpress as the server.

  6. Right Click on the Databases folder and select Attach.

  7. On the Attach dialog, click “Add”. Browse to locate and select the ProMapper.mdf file.

  8. Click OK. The database should be attached. Exit SQL Server Management Studio.

ProMapper Client Installation

  1. Run ProMapper setup.exe on the client.

  2. Start ProMapper. You will be prompted to register. Complete and submit the registration using the supplied registration code. Close ProMapper.

  3. If you are using a local SQL Server Express, logging into the database should be automatic. If you are using an enterprise SQL Server, you will be prompted to log in. Select the Server (type it in if the server name doesn’t appear in the dropdown). Check “Use Integrated Security” unless your SQL Server administrator provides you with a username and password. Then select the ProMapper database. Ordinarily, this will be called ProMapper, but it could have been renamed. It’s also possible to have more that one ProMapper database attached to the server and switch between them (for example, for training).

⚠️Note: ProMapper requires MDAC, and Jet. In most cases, these packages are already installed with Windows. If you receive an error indicating one of these is missing, please contact support for further installation instructions.

Setup a Backup Procedure

It is very important to create a backup/restore process that is scheduled, automatic and verifiable. Please check with your dba to make sure any ProMapper databases are in the backup rotation. See the related articles for backup options and best practices.

Revised: 2014-10-16