Connection Manager

Updated in 8.5

The Connection Manager is an Network Inventory tool for managing connections to Network Inventory. A connection defines which Network Inventory database to connect and what technician account to use for this connection.

Typically, you use only one connection that is provided by your Network Inventory administrator, and you do not need the Connection Manager to manage it.

Run the Connection Manager only when you need to fine-tune your existing connection (for example, to specify the network address of the SQL Server where your database resides) or to create additional connections. Additional connections are required if you work with more than one Network Inventory database or when you need to log in to the Network Inventory under different accounts (for example, when testing the workflow). When you have more than one connection, the Log in to Network Inventory window shows the Connection drop-down list, and you can choose the desired one when logging in to Network Inventory.

To create a connection:

  1. In the Log in to Network Inventory window, click Manage Connections to bring up the Connection Manager window.

  2. In the left pane, click the Plus button . To create a connection by copying an existing one, select the original connection and click the Copy button .

  3. In the Name field, specify the connection name. This name will help you identify this connection when logging in.

  4. Under Technician Account, provide the credentials of the Network Inventory account that will access the database using this connection.

  5. If the Access Key section is empty, click Import and import the Database Access Key using the Access Key Import window. This populates fields in the Access Key and Database Connection sections with the values from the imported key.

  6. Under Database Connection, fine-tune the database connection details, if needed: .

    • In the SQL Server field, enter the network address of the SQL Server, which may differ from the SQL Server name specified in the Database Access Key.

    • To enable support for TLS 1.2, select the Enable TLS 1.2 support check box. When the box is selected, the app will use Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL).

      NOTE: Using the MSOLEDBSQL driver is required when your SQL Server administrator upgrades to TLS 1.2 on the SQL Server, as recommended by Microsoft. For details, see Microsoft OLE DB Driver for SQL Server is disabled or missing.

  7. Click OK.

Connection Manager window

Use the Connection Manager window to create new connections, modify the existing connections, or to delete the connections that you do not need.

TIP: To access the Connection Manager window, click Manage Connections in the Log in to Network Inventory dialog box.

The left pane displays all the connections that are available on the local computer, and allows you to create, delete, and copy connections.

The right pane displays the details on the selected connection:

Name - the connection name.

The Access Key section displays the details about the Database Access Key imported to your computer. Your Network Inventory administrator may need this information to identify the key and verify it.

The Database Connection section displays the details on the database connection, and lets you fine-tune and test the connection:

  • SQL Server - the network address of the SQL Server hosting the Network Inventory database (for example, sqlserver.example.com) that the connection will use to access the SQL server from your local computer.

  • IMPORTANT: The network address may differ from the SQL Server name specified in the Database Access Key. If the SQL Server instance uses a non-standard port, include the port number after the SQL Server's name, such as: sqlserver.example.com, 3487.

  • Database - the database name. Typically, this is the database specified in the Database Access Key.

  • Test Connection - verifies the connection.

The Technician Account section displays the details on the Network Inventory account:

  • Authentication - the authentications type (either Windows Authentication or Standard Authentication)

  • Username - the Network Inventory user name. For Windows Authentication, it is your current Windows user name.

  • Password - the Network Inventory password.

  • Advanced Login Screen - shows additional controls in the Log in to Network Inventory window. In the Advanced mode you will be able to specify a different SQL Server, database, or authentication type, if this choice is supported by the Database Access Key. Please contact your Network Inventory administrator for information to be used.