Skip to main content


 

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.

 

 



 
Be the first to reply!

Reply