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

CADWorx Structure Installation

Installation & Upgrade
20.1 (2020 R1)
2020 R1 (4.1)

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.