When I click "Test Connection" button, "Connection Failed" message is displayed

Installation & Upgrade
Please make sure that the following conditions are fulfilled:
  • MS SQL Server is installed on a machine which you're specifying in the EP installer;
  • SQL server Username and a Password entered by you are valid, and the SQL user account has a permission to create a new database;
  • The SQL server is setup for using SQL (mixed mode) authentication:

  •  


If you are not sure if specific SQL user account has permissions to create a new database, try to use "sa" username.

Another way to check is to open the SQL Server Management Studio, and login to your SQL server using "sql authentication".  If you can login using an sql user name, and password, then you are using the right info, but another problem maybe the name of your SQL server.  Make a note of the server name you are logging in to, at the SQL Server Management Studio login, and make sure you use this name during the EP setup process.





Please note that for the case of using locally installed SQL Server Express with a default instance name you should enter (local)\sqlexpress in the EP installer.




If you have SQL Server Express the following things must be enabled in its properties:

 
  • login for the 'sa' user:
  • remote connections:
 
 
  • TCP/IP protocol:


Note: after any changes to enable the above info, you must restart the SQL server service, to have the changes take effect.