New article
Recently updated
Ideagen Internal Audit (Aura): Error "Cannot open database [...] requested by the login. The login failed"
When accessing the application the user receives an error beginning:
Universal Time: (2022-10-12 11:35:25) Local Time: (2023-09-18 12:35:25) TimeZone: (01:00:00 DST)
Version: 6.0.1.3
EXCEPTION: ProtocolException
message: The content type text/html; charset=utf-8 of the response message does not match the content type of the binding (application/soap+xml; charset=utf-8). If using a custom encoder, be sure that the IsContentTypeSupported method is implemented properly. The first 1024 bytes of the response were: '<!DOCTYPE html>
<html>
<head>
<title>Cannot open database "Pentana6013" requested by the login. The login failed.<br>Login failed for user '[user name]'.</title>
This is caused by a problem with database access:
- the database user may not be mapped to the correct database login
- if the service uses a SQL login then the username or password may be incorrect
- the database name may be specified incorrectly in the configuration file
In order to resolve:
- ensure that the SQL Server login is mapped to the correct database user (and then also ensure the correct roles)
- check the file Service\Web.config - ensure the database name is correct and if a SQL account is used that the username/password are correct
- if any of these details are incorrect then check the Web.config files for the applications FBA and WebUI