Configuring Intergraph Smart 3D Application Servers and Databases Creations

This article is in continuation of installing-intergraph-smart-3d-application

Configuring Intergraph Smart 3D application involves a laborious set of manual tasks as detailed below

On App server and the DB server (in case if you use remote DB server for hosting DBs):

• · Control PanelSystem and SecurityAdministrative ToolsComponent Services
• · In Component Services>Computers> My Computer > Distributed Transaction Coordinator > Local DTC
• · Right click Local DTC > Properties > Security > Select all options as shown below
• · Restart the “Distributed Transaction Coordinator” service to get the changes into effect
• · Verify that “Distributed Transaction Coordinator” service is running and set to start automatically

Only on App server:

1. · Make sure that Demo users group is member of “Distributed COM Users” group on the server
2. · Add Application server > Role service > COM+ Network Access
3. · In Windows Firewall
   • Create a new Inbound rule to all port 135 for all connections and all profiles and name it as RPC with description (For Intergraph SmartPlant 3D Name Generator)
   • Updated the newly created rule to > Protocols and Ports > Local Port > RPC Dynamic Ports
   • Create a new Inbound rule to allow program “%SystemRoot%System32msdtc.exe” for all connections and all profiles and name it as MSDTC (For Intergraph SmartPlant 3D)
   • Create a new Outbound rule to allow program “%SystemRoot%System32msdtc.exe” for all connections and all profiles and name it as MSDTC (For Intergraph SmartPlant 3D)
4. ·  Create ShipCatalogData Share folder
   1. C:Program Files (x86)SmartPlant3DRefDataShipCatalogData –as- \TESTSRV2ShipCatalogData and
   2. give everyone Full permission on the share
5. Create SharedContent Share folder
   1. o C:Program Files (x86)SmartPlant3DRefDataSharedContent –as- \TESTSRV2SharedContent and
   2. o Give everyone read and change permissions
6. Run caspol.exe to add SharedContent path to the .Net Trusted path
   1. C:>C:packagingcaspol.bat
   2. Enter SP3D/SM3D SharedContent directory (no trailing backslash, no quotes) (e.g., \servernamefolder): \TESTSRV2SharedContent
   3. Microsoft (R) .NET Framework CasPol 2.0.50727.5420
   4. Copyright (c) Microsoft Corporation. All rights reserved.
   6. Added union code group with "-url" membership condition to the Machine level.
   7. Success
   8. Press any key to continue . . .
   10. C:>
7. SQl Database: Should be 2008 SP3 Standard/Enterprise
8. DB configuration running user should have SysAdmin role on the DB instance
9. Register the SQL Server by Opening SQL Studio, connect to DB instance, right click the instance after connecting and then click Register
10. In the “New Server Registration”, set Login to sa user, Click Test, if successful, then click save

Related screenshots:

Creating Intergraph Smart 3D DataBases and Configuring

1. Launch Start MenuProgramsIntergraph SmartMarine 3DDatabase Tools
2. Select “Create a new site” and in the next wizard fill the details shown below respectively and click Next
   1. 1. Database Type:
      1. § Site DB Server : TESTSRV2SMART3D
      2. § Site DB name: S3D_V11R1_SDB
      3. § Site DB workshare location: USA
      4. § Name Rule ID: 1
      5. § Name Generator server for site: TESTSRV2
   2. 2. Create Site Schema database:
      1. § Template File for site schema: \TESTSRV2ShipCatalogDataDatabaseAppRepos.dat
      2. § Site Schema server: TESTSRV2SMART3D
      3. § Site Schema name: S3D_V11R1_SDB_SCHEMA
3. In Catalog Database and Schema dialog, choose “Use existing catalog created in Project Management or Bulkload”
4. Click next in “Ready to load databases”
5. Upon successful installation, click Finish

   1. Launch Start MenuProgramsIntergraph SmartMarine 3D Project Management

   1. Click Database > New > Catalog…

   2. In the New Catalog wizard input below values

   § Catalog DB server: TESTSRV2SMART3D

   § Catalog DB name: S3D_V11R1_CDB

   § Catalog DB server: TESTSRV2SMART3D

   § Catalog DB server: S3D_V11R1_CDB_SCHEMA

   § Template Options: choose Create a new catalog from a template: change template path from \TESTSRV2DatabaseTemplatesCatalogDB.dat to \TESTSRV2ShipCatalogDataDatabaseSM_ShipCatalogDB.dat

   § In Symbol and custom program file location : type: \TESTSRV2ShipCatalogDataDatabaseSM_ShipCatalogDB.dat

   2. Upon successful catalog creation, select the SmartMarine 3D in ‘Project Management’ , goto Database > New > Ship >

   1. In general tab give: Name = S3D_V11R1_MDB; Description = For Test from TESTSRV2

   2. In Databases tab in below values as shown

   

   From drop down list select each of below DBs, their server and DB names as required

   § Catalog: S3D_V11R1_ CDB

   § Model: S3D_V11R1_ MDB

   § Reports: S3D_V11R1_ RDB

   § Name Generator server for ship: TESTSRV2

   3. Then click OK

    

   Related Screenshots: