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 and appsettings.json files 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.

Make sure your SQL server has a login named 'JitbitHelpdeskUser', make sure that the database has a database user with the name name and this user is mapped to the login.

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.