Define the main user and create databases

Define the main user and create databases in Microsoft SQL Server Management Studio.

You will need to create three databases:

• EDBManagement is the management database.

• EDBProject is a project database that contains all the CADMATIC Electrical project data in the SQL Server instance.

• EDBUserCommon contains the shared design content, such as cable types, product information, and plate defnitions.

Do the following:

1. Add a new user (who you will define as the main user later):

   1. Open Security > Logins. This folder contains all SQL Server users and user groups.

   2. Right-click Logins, and select New Login.

      

      The Login - New dialog opens.

   3. For Login name, enter the username in the format [domain name]\[Windows username].

   4. Click OK. The program creates the new user into the user folder.

2. Create the databases:

   1. Right-click Databases, and select New Database. The New Database dialog opens.

   2. In the Database Name field, enter EDBManagement. The program creates two files: a ROWS file that contains the actual database data, and a LOG file that contains the SQL commands that are sent to the database.

      

   3. Define the default sizes:

      1. For the ROWS file, for Initial Size, enter 64 as the value.

      2. For the LOG file, enter 32 as the default size.

   4. Define the growth rates:

      1. For the ROWS file, below Autogrowth / Maxsize, click the button. The Change Autogrowth for [file name] opens.

      2. For In Megabytes, enter 32 as the value.

      3. Click OK.

      4. Enter 16 as the growth rate for the LOG file as described.

         

   5. Check the default file location in the Path column. You do not need to change the location at this point, but note that the program does not create backups of the files, so you have to do that yourself.

   6. Click OK.

   7. Create two more databases named EDBProject and EDBUserCommon as described, with the following definitions:

      Database	Type	Default size	Growth rate
      EDBProject	ROWS	512	256
      	LOG	128	64
      EDBUserCommon	ROWS	128	64
      	LOG	64	32

3. Define the main user for the databases:

   1. Open Security > Logins.

   2. Right-click the user name you added in step 1, and select Properties. The Login Properties - [User name] dialog opens.

   3. Select User Mapping.

   4. On the Map column, select the databases you just created.

   5. For Default Schema, enter dbo as the value for each database.

   6. One by one, on the list in the bottom of the dialog, select db_owner for each database.

      

   7. Click OK. The program adds the user as the main user for the databases. If you want to check that everything is in order, select Databases > [Database] > Security > Users. The user is visible in the user list.

Next, configure the firewall.