Smart 3D Database - SQL Server Settings - Intergraph Smart Reference Data - Version 10.1 - Customization & Programming - Hexagon

Intergraph Smart Reference Data Integration (10.1)

Language
English
Product
Intergraph Smart Reference Data
Search by Category
Customization & Programming
Smart Materials/Smart Reference Data Version
10.1

By default, SQL Server does not allow remote access connections. For this reason, we must set up the Smart 3D SQL Server settings as described below.

SQL Server 2014

  1. Make sure that both the Smart 3D server and the Smart Reference Data server are in the same workgroup (or same domain).

  2. On the Smart 3D server and on the Smart Reference Data server, create or choose any local user for running the Load API. The reason is that SQL Server must be allowed to connect to the server by Windows Authentication.

    It is sufficient to create a limited Windows user with restricted rights, but it is also possible to use the Administrator user or to add a domain user with access to both servers.

    Example:

    Domain user: ingrnet.com\sp3dadmin

    Local user: sprdint

    71 (1)

  3. Launch SQL Server Management Studio on the Smart 3D server.

  4. Expand the Security > Logins node and add a new username.

    72

  5. Enter the login name, select Windows authentication, and click OK.

  6. Select the Map check box for all databases as displayed in the picture below.

    73

  7. In the Database role membership field at the bottom, select db_datareader, db_datawriter, and public for the catalog database, and then click OK.

  8. Close SQL Server Management Studio.