Connecting to Microsoft SQL Server Databases

Atlas Hub requires Microsoft SQL Server authentication to connect to Microsoft SQL Server databases, rather than the default Microsoft Windows authentication. If you install Microsoft SQL Server using the default settings for security and authentication, Atlas Hub will experience problems connecting to the database.

To specify the security to use when connecting to Microsoft SQL Server:

  1. Start the Microsoft SQL Server Installation Wizard.
  2. Go to the Authentication Mode page of the wizard.
  3. Select Mixed Mode (Windows Authentication and SQL Server And Windows option button (instead of the Windows Only option).
  4. Type and retype the password to use.
  5. Click Next to complete the rest of the wizard.