Website is unavailable: Failed to login to session state SQL server for user

Symptoms

A website is unavailable:

CONFIG_TEXT: Server Error in '/' Application. Failed to login to session state SQL server for user 'jdoe'. [SqlException (0x80131904): Login failed for user 'jdoe'.]

Cause

Incorrect credentials set for database user in %plesk_vhosts%example.com\httpdocs\web.config.

Resolution

1. Log into Plesk.

2. Open Domains > example.com > Databases > example_db > jdoe.

3. Change password to the necessary one.

4. Connect to the server via RDP.

5. Open %plesk_vhosts%example.com\httpdocs\web.config.

6. Find "<ConnectionStrings>" section and type correct IP address of the database server and credentials - user and passpword:

   CONFIG_TEXT: <connectionStrings> <add name="example_db" connectionString="Persist Security Info=True;Initial Catalog=example_db;Data Source=203.0.113.2;User ID=jdoe;Password=password" /> </connectionStrings>