Skip to main content
Nintex Community Menu Bar

Problem trying to add custom service broker using service broker management tool

  • October 8, 2015
  • 0 replies
  • 11 views

Forum|alt.badge.img+18


 

Symptoms

 


When attempting to click on the "configure service" in the service broker management tool, the following error occurs:

System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
 

 

Diagnoses

 


This is a bug that was discovered in 4.6.9 and is fix in version 4.6.11.
 

 

Resolution

To resolve the issue pre-4.6.11 release, please navigate to the 'BrokerManagement.exe.config' file located at (C:Program Files (x86)K2 blackpearlServiceBroker). How does the 'SmartBrokerDB' connection string currently look?

<add name="SmartBrokerDB" connectionString="Data Source=PANDD-SP2013;Initial Catalog=K2;integrated security=sspi;Pooling=True" providerName="K2BLACKPEARL" />

If applicable, please update the "Data Source" (your SQL server) and "Initial Catalog" (the K2 database name) parameter to the appropriate value in your environment and retest.