Error: Login failed for user 'JitbitHelpDeskUser'

Question:

Upgrade was successful, but when I try to log in to the website, I get the following error:

There was an error initializing the app. Make sure the database server is properly configured and you upgraded the database (in case you recently updated the app).
Error message:

System.TypeInitializationException: The type initializer for 'InstanceSettings' threw an exception. ---> System.Data.SqlClient.SqlException: Login failed for user 'JitbitHelpDeskUser'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, ...



Answer:

Please check the connection string in your web.config file and make sure it points to the right database and provides correct credentials. When upgrading, you should use the web.config file from your existing version and never overwrite it with the file from the distributive.

Also, please make sure that user 'JitbitHelpDeskUser' is set as database owner for the 'JitBitHelpDesk' database.

This should resolve the issue. If any problems remain, please message us; we will do our best to get them solved as soon as possible.
Description of known error messages and respective solutions.
Creation date: 19/12/2016 08:40     Updated: 19/12/2016 08:49