Creating a new Civil Pro database

To create a new database

At the Log In screen:

  1. click on the Select Database button in the top right
  2. select New Connection button

Configure the Data Source

Once you have decided whether to use a standalone file (essentially single user) or SQL Server (multi-user or single user), select the correct option in the Select Source section at the top of the page, and follow the instructions below.

Standalone File

After selecting a New Connection, the following window will be visible:

StandaloneConnection

To make a standalone project:

  1. select the Civil Pro Data File option in the Select Source section
  2. click New Standalone File link
  3. in the Save File dialog, type a new name for your project’s database
  4. click Save
  5. You will be returned to the Connection screen. Unless you have a security reason for doing so, it is generally easiest NOT to password protect standalone files.
  6. Click on the Connect button
  7. You will be prompted to initialize the database. Click on the Yes button and follow the prompts per the section on initializing a new database below.

 SQL Server Database

Selecting an SQL Server will give the following connection builder:

To make a project on an SQL Server:

  1. Select the SQL Server option in the Select Source section.
  2. Type in the name of your SQL Server, or select it from the list if it is broadcast on the network.
  3. Depending on the security model used by your server, select Integrated Security or SQL Security. If you select SQL Security, you must provide the SQL username and password.
  4. If your credentials have been entered correctly, the databases present on the server will be listed in the database drop down editor. As you are creating a new database on this server, click the Add button and enter the name for your database (no spaces or non-alphanumeric characters).

  5. Click OK. You will be returned to the Connection screen.
  6. Click on the Connect button.
  7. You will be prompted to initialize the database. Click on the Yes button and follow the prompts per the section on initializing a new database below.

Initializing the Database

The Database Setup window will be displayed.

NewDatabase

  1. Enter the user details (or leave the sysadmin user if you prefer).
  2. Enter and confirm your password.
  3. Enter your email address.
  4. Click Next.
  5. Click Finish.

Your database is initialized. You will be returned to the log in page.

When you log on to your new database, the new project wizard should start automatically.