Error 500 when connecting to AirKey server
Posted by Mikhail Yakovlev, Last modified by Mikhail Yakovlev on 17 May 2019 12:00 PM
- The AirKey Enterprise data storage resides in MSSQL. MSSQL account is used to login to database.
- The AirKey Enterprise data storage resides in Active Directory. Active Directory user service account is used to connect to storage.
The following error occurs while configuring the Indeed AirKey Enterprise via Indeed CM.
HTTP 500 - Internal Server Error
- For MSSQL:
- SQL Server and Windows Authentication mode is disabled
- The account used for connection does not have db_owner privilege for the SQL database.
- Error in Indeed AirKey Enterprise server configuration file.
- For Active Directory - The service account probably does not have privileges for container where the data storage resides.
- For MSSQL:
- Run Microsoft SQL Server Management Studio, connect to SQL server, open its Properties and switch to Security tab. Enable SQL Server and Windows Authentication mode and restart the MSSQLSERVER service.
- Run Microsoft SQL Server Management Studio, connect to SQL server and switch to Security - Logins. Switch to User Mapping section of account properties and add db_owner permission, then click OK.
- Verify the Web.config file of AirKey server:
- It might be that quotation mark, a character or a part of <...></...> tag is accidentally deleted in the <connectionStrings>...</connectionStrings> section.
- <Add.../> parameters might be deleted partially or completely.
- A mistype is possible in parameter names (Server, Initial Catalog, Integrated Security, User ID, Password).
- Data for connection to database might be incorrect.
- For Active Directory, allow for full access to container with data storage and all of its child objects.