Installation error: "Cannot establish a connection to SQL Server"

Make sure SQL server allows remote connections. You can test the connection to the SQL server by using a UDL file:
Create a text file with the udl extension on the CardioLog server, open the file, select the SQL provider on the first tab and on the next tab fill in the database server name. Then click test connection.

If you are using a SQL alias, configure it on the CardioLog application server using the clicnfg.exe utility.

 

Please note that the account used for installing CardioLog should have the following SQL roles and permissions:

  • "create any database", "alter any login", "view server state" permissions (required only for installation) and the processadmin role on the SQL server
  • db_datareader for the SharePoint configuration and content databases.

 

Next, make sure the database allows remote connections with this account.
You can test the connection to the database using a UDL file - create a text file with the udl extension on the CardioLog server, double click on it, choose the SQL provider on the first tab and on the next tab fill in the database server name. Click test connection.

 

Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk