Unable to Start AdminUI
Here are some common startup issues you may face when initially trying to start AdminUI.
Database Errors On Startup
Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'Description'. Invalid column name 'Reserved'.
The above errors would usually indicate that the ASP .Net Identity schema hasn't been migrated to the IdentityExpress identity schema required for AdminUI. Documentation on migrating this schema can be found here.
Bootstrap issues
When the bootstrap process fails at any point it will rollback to its previous state before the bootstrap ran. This is indicated in the logs by the message "Bootstrap Failed - Rolling Back".
This usually happens when there is conflicting data in your database. If this is the case then you can check your logs for the error by going to your logs directory, if you haven't already enabled logs please see our enabling logging section.
If this is the case please email us with your logs at support@identityserver.com
Database connection
One known problem is with SQL Express and SQL logins. When installing SQLExpress for the first time, it defaults to use Windows Authentication. This means that you can’t log into any of the databases using SQL logins. To solve this problem, change this SQL Express setting to allow SQL logins.
Another problem can be with improperly escaped SQL Express connection strings e.g. using 'localhost\SQLExpress' instead of '.\SQLExpress' would result in the same error.
SqlException: A network-related or instance-specific error occurred while establishing a connection
If you receive this error, the API cannot connect to the database. It may be that the connection string is invalid or that the website is unable to resolve the server name.
SqlException: Login failed for user
Check that the user name is correct and that the user has the correct permissions.
If you receive this error, the API is not authorized to access the database. It may be that the user in the connection string is invalid or is not authorized to access the database.
SqlException: A connection was successfully established with the server, but then an error occurred during the login process
If you receive this error, the API is not authorized to access the database. In this case, it may be that the website user is trying to use SQL authentication (a username and password) but the database only supports Windows authentication.
To resolve this, we recommend enabling SQL authentication in your database. This is often required when using SQL Server Express from IIS.
Support
If none of these steps work or you are unsure how to fix the error in the logs, please contact us at support@identityserver.com, detailing the issue you see, including any error logs.