User Guide

To connect to an existing Microsoft SQL Server database:
1. During the installation, on the Database Selection screen, select the Connect to existing Microsoft SQL
Server database radio button and click Next. The Existing Microsoft Server Database Configuration screen
opens. A new database will be created at the location of the existing database.
2. Go to the system where the existing database is located and select Start, Programs, Microsoft SQL Server.
The Microsoft SQL Server Management Studio software opens.
3. Connect to the database engine.
4. Create a Login (optional).
a. Expand the security folder.
b. Right-click and select New Login.
c. Enter a login name.
d. Select SQL Server authentication.
e. Enter a password twice.
f. De-select Enforce password policy, Enforce password expiration and User must change password at
next login.
g. Click OK.
h. Right-click Databases and click New Database.
i. Enter a database name.
j. Assign an owner.
k. Click OK.
l. Exit the Microsoft SQL Server Management Studio software.
m. Close the system where the new database was created.
5. Go back to the Installation process at the Existing SQL Server Database Configuration screen and enter the
new database information.
a. Database Server - (Port 1433) - The system where the new database was created.
b. Database Name - The Database name entered in the previous steps.
c. Username - Enter the owner assigned to the database.
d. Password - Enter the password assigned to the database owner.
6. Click Install. The installation begins.
7. Upon completion, the Install Complete screen opens.
8. Click Done.
9. Continue as instructed in the Installation on page 11 section.
Moving from PostgreSQL to Microsoft SQL
If you previously installed the application using a PostgreSQL database and wish to use MS SQL, you must
export your plans to a spreadsheet using the plan exporter and generate .pdf files for your project properties.
42 Data Center Planner Installer/User Guide