Assign System Administrator Privileges for SQL Server 2012 - CADWorx - Installation & Upgrade

CADWorx Structure Installation

Language
English (United States)
Product
CADWorx
Subproduct
Structure
Search by Category
Installation & Upgrade
CAESAR II Version
13
CADWorx Version
20.2
CADWorx Structure Version
4.2

Perform the following steps on the CADWorx database server.

  1. Open Microsoft SQL Server Management Studio and expand the listing for your database server in the left tree view.

  2. In the tree view, expand the listing under Security, right-click Logins, and select New Login.

    The Login - New dialog box displays.

  3. Type the user account to be assigned administrative privileges in the Login name text box. For example, type AdminUser1.

  4. Select Server Roles under the Select a page heading to display the Server Roles list.

  5. In the Server Roles list, select the sysadmin check box.

    • Administrators need the sysadmin role. Standard users need public, db_datareader, and db_datawriter database role membership mapping to each one of the CADWorx databases. Standard users also need Execute permission to each database.

    • We do not recommend granting standard users db_owner permissions as it gives the users a very high privilege to the database.

  6. Click OK.