SQL Server Express/Web/Standard/Enterprise (x64)

If you are going to use SQL Server Express/Web/Standard/Enterprise (x64) as a storage solution for Microsoft 365 application endpoint data, you must install SQL Server and prepare databases.

The following database requirements must be met for each database:

  • A high-availability solution is configured for the database if it is required.
  • The database storage device must have enough disk space for the planned amount of Microsoft 365 subscriptions (5 MB of disk space is required to store the data of 1000 Microsoft 365 subscriptions).
  • The Server authentication property of the SQL Server instance of the database is set to SQL Server and Windows Authentication mode. Use the instructions provided below to set this property.
  • The TCP/IP protocol is enabled for the SQL Server instance of the database. Use the instructions provided below to enable the protocol.
  • The Collation property of the database is set to Latin1_General_CI_AS. You can set this property when the database is created. Also, you can use the instructions provided below to set this property after creating the database.

  • The following login is created for the database:

    • The SQL Server authentication option is selected.
    • The Enforce password policy property is turned off.
    • The database is specified in the Default database property.
    • The sysadmin server role is assigned.
    • There is a user mapping where a user is mapped to the database. The Default Schema property of the mapping is set to dbo and the Database role membership property of the mapping contains the db_owner value.

    Use the instructions below to create this login.

  • The following database information is prepared:

    • The name of the database. Examples: Microsoft365GatewayApplication01, Microsoft365GatewayApplication02.
    • The name of the login. Examples: Microsoft365GatewayApplication01, Microsoft365GatewayApplication02.
    • The password of the login.
    • The hostname or IP address of the SQL Server instance. For example: m365sql.hosting.local.
    • The name of the SQL Server instance if a non-default SQL Server instance is used. For example: Microsoft365Instance.

Notes:

1. To obtain information about high-availability solutions of SQL Server, refer to https://msdn.microsoft.com/en-us/library/ms190202.aspx.

2. To obtain SQL Server installation and configuration instructions, refer to https://msdn.microsoft.com/en-us/library/bb500469.aspx.

To set the Server authentication property of the SQL Server instance of a database, perform the following actions:

  1. Connect to the required SQL Server instance using Microsoft SQL Server Management Studio.
  2. In the navigation area, right-click the SQL Server instance and select Properties.
  3. Select the Security page.
  4. In the Server authentication group, select SQL Server and Windows Authentication mode and click OK.
  5. Restart the SQL Server instance.

To enable the TCP/IP protocol for the SQL Server instance of a database, perform the following actions:

  1. Open SQL Server Configuration Manager.
  2. In the navigation area, go to SQL Server Network Configuration > <the required SQL Server instance>.
  3. Right-click the TCP/IP protocol and select Enable.

To set the Collation property of a database, perform the following actions:

  1. Connect to the required SQL Server instance using Microsoft SQL Server Management Studio.
  2. In the navigation area, right-click the required database and select Properties.
  3. Select the Options page.
  4. Set the Collation property to Latin1_General_CI_AS and click OK.

To create a login for a database, perform the following actions:

  1. Connect to the required SQL Server instance using Microsoft SQL Server Management Studio.
  2. In the navigation area, go to Security > Logins and right-click the Logins item.
  3. Select New Login.
  4. On the General page, specify the Login name property. Examples: Microsoft365GatewayApplication01, Microsoft365GatewayApplication02.
  5. On the General page, select the SQL Server authentication option and specify the Password and Confirm password properties.
  6. On the General page, clear the Enforce password policy checkbox.
  7. On the General page, specify the database in the Default database property.
  8. Select the Server Roles page.
  9. On the Server Roles page, select the sysadmin server role.
  10. Select the User Mapping page.
  11. On the User Mapping page, create a user mapping by selecting the Map checkbox and setting the Default Schema property to dbo for the database.
  12. On the User Mapping page, select the user mapping and grant the db_owner database role.
  13. Click OK.

© 2022 Ingram Micro, Inc. All Rights Reserved. Privacy Policy, Terms of Use and Legal