Applicable to:
- Plesk Onyx for Windows
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
-
Open Domains > example.com > Databases > example_db > jdoe.
-
Change the password to the necessary one.
-
Connect to the server via RDP.
-
Open
%plesk_vhosts%example.com\httpdocs\web.config
. -
Find "<ConnectionStrings>" section and type correct IP address of the database server and credentials - user and password:
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>
Comments
0 comments
Please sign in to leave a comment.