Configuring the Database

Parent Previous Next

Configuring the Database


Metropolis can be run on Microsoft SQL Server Express or Microsoft SQL Server. Either of these need to be installed before installing Metropolis.


When you first run the installer, you will see the form to configure the database. Metropolis requires tables to be created and data to be inserted into those tables to run. This area of the installer will install all the required database tables and data to run Metropolis.


It is recommended that you give Metropolis its own database rather than install it on a database with existing tables on it. This protects your databases by isolating each system into its own database.


Creating a New Database and User


If you would like the Metropolis Installer to create a SQL Server user and database for you, select Create Metropolis on a new database and login. Once this is selected, a SQL Server Admin Login group box will appear. Enter the name of the SA or any user with permissions to create databases, create logins, create users and create tables and insert data. The Database text box will be the name of the new database and the New Metropolis Login will be the login and password for the new SQL Server Metropolis user.



Database Server - The host address of the SQL server. This can be a UNC name such as DYSR-DEV-WIN or a DNS host name like dev02.dysr.com.


Database- The database inside the SQL server host that will hold Metropolis data.


Authentication- Select whether Metropolis will use Windows Authentication or SQL Server authentication when connecting. Windows Authentication uses the domain or local user that is used when installing the Windows service which is configured here. SQL Server authentication allows you to enter a user name and password to connect to SQL Server.


Login- This is the user name of the SQL Server user that will be connecting to the Metropolis database. This is only available when using SQL Server authentication.


Password- The password for the login. This is only available when using SQL Server authentication.


This is an existing database and user- Select this when you have already created a user and database for Metropolis and you would like the tables and data to be created, but not the user and database to be created.


[Test Connection]- Before you can create the database and data, you need to test the connection by clicking the [Test Connection] button. A successful connection will look like this:



Once the installer is able to successfully connect, the [Create Database] button is available. A warning will appear and click [OK] if you are sure.



If there are tables that exist in the database you've selected, a warning will appear listing the tables that were found.



Clicking [OK] will drop the tables found and recreate them. [Cancel] will cancel the create database process.


If the database already exists in SQL Server, the following message will appear. If the database you entered is correct, This is an existing database and user is most likely the best option.



Once the database, login, tables and data have been created, a notification box will appear.



Using An Existing Database User


The simplest install is to create tables and data for an existing user. If you already have a user and database created on SQL Server, simply add the information in the installer.



Click [Test Connection] and then [Create Database] and the Metropolis Installer will create the tables and data in the database you provided.

Created with the Personal Edition of HelpNDoc: Easy to use tool to create HTML Help files and Help web sites