Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Archive > 2017September27 - Cleanup > Connect to SQL Server using Named Pipes for DPA 8.0

Connect to SQL Server using Named Pipes for DPA 8.0

Table of contents

 

 

Overview

By default, Ignite connects via TCP/IP when creating a repository in SQL Server or registering a SQL Server instance to be monitored.

Ignite can be configured to connect using Named Pipes. 

Connections to an Ignite Repository on SQL Server using Named Pipes may provide better performance when the Ignite PI Server and repository are located on the same machine.

Environment

DPA version 8.0

Steps

1. In the Database Instance Registration or Repository Creation Wizard, click the Advanced Connection Properties link.

new_named_pipes(1).jpg

 

2. In the JDBC URL Properties field,  enter namedPipe=true, and then click OK.

new_named_pipe_setting.jpg

 

Ignite will now use Named Pipes to connect to the SQL Server instance.

 

Use Named Pipes by Default

If the Repository has already been created, the connection can be changed to use Named Pipes for all new database registrations. 

1. Open repo.properties file found in  <ignite_install_directory>/iwc/tomcat/ignite_config/idc.

2. Add the following line:

repo.jdbcDriverProperties=namedPipe=true

 

Update an Existing Database to use Named Pipes

To use Named Pipes when connecting to an existing SQL Server instance:

1. Go to the Options page.

2. Run the Update Monitored Database Connection wizard. 

3. Select JDBC URL Properties.

4. Enter namedPipe=true, and then click OK. 

 

Limitations:

  • The driver used by Ignite for SQL Server connections does not support the Named Pipe at a location other than /sql/query on the server.
  • Named Pipe connections are not supported for Ignite installations on non-Windows machines.
  • If Ignite is running as a Windows service, the service must be running under a valid domain account (i.e., not Local System account).
Last modified
16:32, 27 Sep 2017

Tags

Classifications

Public