HomeSupercharger KBHow ToAfter installation Supercharger displays "Please provide credentials to an existing Supercharger database or location where a new Supercharger database will be created"

5.3. After installation Supercharger displays "Please provide credentials to an existing Supercharger database or location where a new Supercharger database will be created"

After installation Supercharger displays a Database State page with "Please provide credentials to an existing Supercharger database or location where a new Supercharger database will be created"

This usually indicates on of the following reasons. Please use the suggested steps to resolve.  It will help to install SQL Server Management Studio to perform most of the steps.

SQL Server 2016 is already installed

  1. Enable SQL Authentication (mixed mode) https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/change-server-authentication-mode
  2. Run the following commands to create a user account for Supercharger. Specify a secure password in place of  ????????????????

USE MASTER
CREATE LOGIN ScManagerDbUser WITH PASSWORD=N'????????????????', CHECK_EXPIRATION=OFF
GRANT CONNECT ANY DATABASE TO ScManagerDbUser
ALTER SERVER ROLE [sysadmin] ADD MEMBER ScManagerDbUser

  1. Open Supercharger in your browser
  2. Provide the name SQL Server (localhost) including instance if applicable. If default instance just put localhost.  (If SQL Server certificate is used, provide the same FQDN as in the CN of the certificate.)
  3. Specify the username and password from above
  4. Click Continue

SQL Server 2016 was installed, uninstalled

  1. Uninstall Supercharger 
  2. Open Registry Editor 
  3. Delete HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\130
  4. Re-install Supercharger

Another version of SQL Server is installed which is using port 1433

If the other version of SQL Server isn't needed stop the service.

If the other version of SQL Server is required then

  1. Enable and start SQL Browser service 
  2. Re-configure SQL Server 2016 Express instance of SUPERCHARGER to use dynamic ports by setting the IPAII Dynamic Port to 0 (zero). https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-server-to-listen-on-a-specific-tcp-port
  3. Restart SQL Server 2016 Express 
  4. Restart Supercharger Controller service
  5. Open Supercharger in your browser. After creating the database, the application should come up as normal

This page was: Helpful | Not Helpful