Configure a site database - Intergraph Smart Interop Publisher - Help

Intergraph Smart Interop Publisher Help

Language
English
Product
Intergraph Smart Interop Publisher
Search by Category
Help
Smart Interop Publisher Version
16.2
  1. If you are starting Smart Interop Publisher for the first time, Smart Interop Publisher displays the Configure Site Database Dialog.
    -OR-
    To create a new site database, click IOP Home Menu > Options Menu > Configure Site Database Command . Smart Interop Publisher displays the Configure Site Database Dialog.

  2. In the SQL Server Name box, select the SQL Server instance name you created for Smart Interop Publisher.

    You can also set up a site database on a remote system where the SQL Server Browser service is disabled by appending the system port number used by SQL Server. Use a comma to separate the system name and server name: [system name]/[SQL server name],[system port number].

    Example:

    System name: US-PPM305

    MSSQL server name: MSSQLSERVER1

    Port number: 24310

    How To Find the Port Number

    To find out the system's SQL Server port number, use the SQL Server Configuration Manager that is installed with your SQL Server installation. The SQL Server Configuration Manager is a Microsoft Management Console snap-in that is available from the Start menu, or can be added to any other Microsoft Management Console display. For details on how to add the SQL Server Configuration Manager snap-in, see the Microsoft Technical Documentation site.

    1. Open the SQL Server Configuration Manager, and go to Protocols for [SQL Server name].

    2. Right-click and select Properties.

      Click the IP Addresses tab and note the number for TCP Port used by IPAll as shown in the example below. This is the port number to enter in Smart Interop Publisher.

  3. Type a name for your site database Name.

  4. When you create a new Smart Interop Publisher site or project database, you can use either the default SQL Server location or specify your own location. Clear Use the SQL Server default locations to select different locations for SQL Server Data Pathname and SQL Server Log File Pathname.
    -OR-
    Keep the Use the SQL Server default locations option selected to use the default location. Default SQL Path displays in the location boxes for SQL Server Data Pathname and SQL Server Log File Pathname, and the software uses the locations defined for these in SQL Server.

    • After you create a database, you cannot change the SQL Server Data Pathname and SQL Log File Pathname locations.

    • If you are creating a project or site connected to a remote SQL Server instance, you cannot change the SQL Server Data Pathname and SQL Log File Pathname locations.

  5. To check the paths, open the SQL Server Configuration Manager and look at the site Properties.

  6. In the SQL Server Data Path Name box, browse to the folder for the site database file.

  7. In the SQL Server Log File Path Name box, browse to the full path of the SQL Server-generated log file.

  8. Keep the Create default project option checked for Smart Interop Publisher to automatically create a project called [site database name]_General. Otherwise, you must create a project before you can add source files.

  9. If you selected Create default project, browse to or type a Shared Content Location. Every Smart Interop Publisher project requires a shared content location. This folder contains internal files used by Smart Interop Publisher to support work done in the specified project.

  10. Click Configure.

    The software creates subfolders under your shared content location in which you can organize all your work for the selected project.

    Unless you specify a location, Smart Interop Publisher uses the shared content location and its subfolders for default location settings.

You can now create the required projects. When you create and change to another site, all projects and project data (source files and Smart Models) are removed from the views. Only projects created within a site display.