0

Database Connection Error: There Was an Error Connecting to the Database

Issue:
Getting an error message saying Database Connection Error: There was an error connecting to the database when running the Pyramid Deployment Wizard.

Scenario:
This issue appear when either an incorrect user was used to connect to the database or the user does not have sufficient permissions.

Solution:
Make sure that the user is an SQL user and not a Windows user and that it has the dbcreator and public Server roles (see attached "SQL User Settings.png" for how this should be configured).
In addition, the SQL server authentication needs to be set to "SQL Server and Windows Authentication mode" under Server Properties. (see attached Server Properties.png)

In case the solution above was implemented and the issue persist, please submit a support ticket by using one of these options:
Log a ticket in the Pyramid support portal: https://support.pyramidanalytics.com
Send an email to support: support@pyramidanalytics.com

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 3 yrs agoLast active
  • 1341Views
  • 1 Following