Installation Error: "There was an error logging in to <DatabaseInstance>"

Products

• Carbon Black App Control

Issue/Introduction

During the installation of App Control, there is an error with database login

• There was an error with logging in to <DatabaseInstance>
  Error: Login timeout expired
  
• There was an error logging in to <DatabaseInstance>
  Error: Login failed for user <Username>
  

Environment

• App Control Server: All Supported Versions

Cause

• SQL Services are not started
• Incorrect instance specified
• Incorrect Username/Password specified
• Username specified does not have permission to the instance
• Network misconfiguration

Resolution

1. Confirm the SQL server services are running
   1. Open services.msc
   2. Confirm the service with the name "SQL Server (<InstanceName>) has the stats "Running".
2. Confirm the server / instance name is correct
3. Confirm connectivity to SQL Server
4. Confirm the account being used has the correct permissions

Additional Information

If the username and password is unknown / not working (even in SSMS), the only option may be to reinstall SQL Server (and re-attach the das.mdf files if doing a re-install)