Initialize the Microsoft SQL Database with Minimum Access Privilege - Intergraph Smart 3D - Installation & Upgrade - Hexagon

Intergraph Smart 3D Installation

Language
English
Product
Intergraph Smart 3D
Search by Category
Installation & Upgrade
Smart 3D Version
13.1

After the Microsoft SQL Server is installed and configured (that is, you can connect from a client to the SQL database), you must configure the database to run with Smart 3D software.

The Reference Data Setup delivers the following sample script files to the <Product Folder>\3DRefData\Tools\SQLScriptsToInitDB folder. These scripts create the minimum access privileges on Microsoft SQL services for the user. These scripts must be run in the following order:

  1. SQLScriptsToInitDB \ S3DProjectAdministrator_ROLES.SQL

  2. SQLScriptsToInitDB \ Windows_S3DAdminUser.SQL for Windows Authentication or SQLScriptsToInitDB \ S3DAdminUser.SQL for SQL Authentication.

  3. SQLScriptsToInitDB \ Windows_S3DStandardUser.SQL for Windows Authentication or SQLScriptsToInitDB \ S3DStandardUser.SQL for SQL Authentication.

    SHARED Tip For assigning the Standard user role, you only need to run Windows_S3DStandardUser.SQL or S3DStandardUser.SQL. The admin scripts are not necessary for assigning Standard user role.

These scripts create the necessary users and roles that are used to run the software on Microsoft SQL with minimum access privileges. The delivered scripts, however, are only samples and must be edited to fit your server configurations.

  • A database administrator who has the sysadmin role must run the scripts on the server. Before proceeding, place a copy of each of the sample scripts on the server computer.

  • The scripts must be run in the order listed because previous scripts create items that are used in subsequent scripts. Do not deviate from the following sequence of steps.