KanBo Error: Cannot Open Database

Table of Contents

In most cases, the issue is caused by an incorrect SQL Server connection string in the configuration file, including invalid database credentials or database name settings. Then, the KanBo log shows that there are problems with the SQL Server.

If your KanBo log file includes any SQL error messages:

  1. Check your connection string in the web.config file.
    SQL connection error messages can look like the following:
Plugins         FATAL | plugin 4544ea97-0711-4506-b034-70908f732750(Effects processor): Caught unexpected exception from effects processor
EXCEPTION: HelpLink.ProdName: Microsoft SQL Server;HelpLink.EvtSrc: MSSQLServer;HelpLink.EvtID: 4060;HelpLink.BaseHelpUrl: http://go.microsoft.com/fwlink;HelpLink.LinkId: 20476
System.Data.SqlClient.SqlException (0x80131904): Cannot open database "KANBO_DATABASE" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\kanboapppool'
  1. See the example connection string below, which includes how it should look with Windows and SQL authentication:
"KanBo": "Data Source=sqlserver,1433;Database=KANBO_DATABASE;User ID=USERID;Password=PASSWORD;TrustServerCertificate=true;MultipleActiveResultSets=True"

Was this article helpful?

Please, contact us if you have any additional questions.