Database connection problems

✖
Copy to clipboard

If you encounter problems when connecting to the SQL server database during the installation or at a later point, make sure that:

  • The target server has Microsoft SQL Server 2008 R2, 2012, 2014, 2016 or 2017 installed and running.
  • You are using the correct instance of the SQL server if the server has multiple instances. The instance name must be entered in format server\instance.
  • The TCP/IP protocol is enabled on the SQL server. You can check using the SQL Server Configuration Manager utility, under SQL Server Network Configuration/SQL Native Client Configuration -> Client Protocols.
  • Access to the database server is not blocked by a firewall (the default port number for the TCP/IP protocol is 1433).

Failed authentication

Error message: Login failed for user ‘username’.

SQL Server accounts

If you are using an SQL Server account with a password to authenticate against the database, make sure that:

  • You are using a valid username and password.
  • The login exists on the server, is enabled and has permissions to connect to the server (check the logins on your server using SQL Server Management Studio in the Server -> Security -> Logins section of the Object Explorer).
  • Your server supports SQL Server authentication (check that the SQL Server and Windows Authentication mode option is enabled in the Server Properties -> Security dialog in SQL Server Management Studio).

Windows authentication mode

To resolve problems with database connections that utilize Windows authentication, you may need to contact your network administrator. The Kentico application runs under a specific local or domain account, depending on your environment (for example NetworkService).

When running the application on IIS, the account depends on the Identity of the assigned application pool. If your SQL server is located on a different machine than your web server, you may need to configure the application pool to run under a domain account rather than a local account.

The account must have its own login created on the SQL server, configured for Windows authentication and with the appropriate permissions. You can manage the logins using SQL Server Management Studio, in the Server -> Security -> Logins section of the Object Explorer.