This article only applies to Squared Up Version 2.0. If you're looking for help with Squared Up Version 3.0, please visit our new knowledge base

Symptoms

You see this error from the SQL plugin:


Error: A network-related or instance-specific error occured while establishing a connection to the 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: Names pipes provider, Error: 40 - Could not open a connection to SQL Server) (2)

Procedure

The message indicates that Squared Up cannot see the database.  Check the connection string in the SQL plugin, especially if you are using an instance and/or a specific port, using the information below.


Database Connection (Connection String)

Data Warehouse

OperationsManagerDW

global:dw

OperationsManager database

Data Source=<server-name>;Initial Catalog=<database-name>;Integrated Security=True;


If the Squared Up server and SQL server are in the same domain:

Data Source=SQLServer1;Initial Catalog=OperationsManager;Integrated Security=True;

If the Squared Up server and SQL server are not in the same domain:

Data Source=SQLServer1.mydomain.local;Initial Catalog=OperationsManager;Integrated Security=True;


If the OperationsManager database is on the same server as the data warehouse you can use:

global:dw

and then put the following at the beginning of the query:

USE operationsmanager;

Any other database

Data Source=<server-name>;Initial Catalog=<database-name>;Integrated Security=True;

For example:

Data Source=SQLServer1;Initial Catalog=CRMDB;Integrated Security=True;

Using an instance

Data Source=<server-name>\<instance name>;Initial Catalog=<database-name>;Integrated Security=True;

Specifying a port

Data Source=<server-name>,<port number>;Initial Catalog=<database-name>;Integrated Security=True;

For example:

Data Source=SQLServer1,51433;Initial Catalog=CRMDB;Integrated Security=True;



See also:

How to configure the SQL plugin

Troubleshooting the SQL plugin