Regenerate the reports database with linked SQL servers - Intergraph Smart 3D - Administration & Configuration - Hexagon

Intergraph Smart 3D Project Management

Language
English
Product
Intergraph Smart 3D
Subproduct
Project Management
Search by Category
Administration & Configuration
Smart 3D Version
13.1

If the site, catalog, and model databases are not on a single server, then you cannot regenerate reports databases until you configure linked servers, as shown in the following procedure.

Verify that both servers support both SQL Server Authentication and Windows Authentication

  1. From the Start menu, open SQL Server Management Studio.

  2. Right-click the server in the Object Explorer, and select Properties to display the Server Properties dialog.

  3. Click Security, and verify that Server authentication is set to SQL Server and Windows Authentication mode.

  4. Repeat this process for the other server.

Create a login with SQL server authentication for both servers

  1. Right-click <ServerName> > Security > Logins, and select New Login to display the Login - New dialog.

  2. Type the name in the Login name box.

  3. Select SQL Server authentication, and type and confirm the password. Clear User must change password at next login if necessary.

  4. Click Server Roles, select sysadmin, and click OK.

  5. Repeat these steps for the other server.

  6. Disconnect both servers, and then verify that you can connect to them with the new SQL login.

Link the servers

  1. Right-click <ServerName> > Server Objects > Linked Servers, and select New Linked Server to display the New Linked Server dialog.

  2. Type the name for the other server in the Linked server box.

  3. Click Security, and select Be made using this security context.

  4. Type the user name into the Remote login box.

  5. Type the password into the With password box.

  6. Repeat these steps for the other server.

Verify the link between the servers

  1. From one of the servers, run the following query:

    Select * from [otherservername].[dbname].[tablename]

    [otherservername] is the name of the other server.

    [dbname] and [tablename] are the names of any existing database and table.

  2. Repeat this process for the other server.

Troubleshooting

Error: Server 'A' is not configured for DATA ACCESS

Recovery: Type the following command into the Run dialog on both server A and the linked server:

Exec sp_serveroption 'A', 'data access', 'true'