Install and configure SQL server

This installation must be performed on the remote server.

Installation steps:

  1. Install the SQL database engine.

  2. Create the SQL logins.

Install the SQL database engine

This installation must be performed on the remote server using the <domain_name>\Administrator account.

  1. Install the SQL engine.

  2. Open the firewall ports 1433, 1434, and 445 for access by the SQL database engine, SQL browser, and Active Directory for domain account authorization.

    sql server inbound firewall rules

  3. Create a test database, if a suitable is not available, for the purpose of this integration.

    test database

Create the SQL logins

  1. Create two SQL logins with the domain accounts <domain>\dbuser and <domain>\dbuser2 with Default Database equal to "TestDatabase".

    sql logins

  2. Set the User Mapping as database owners, db_owner, of TestDatabase.

    testdatabase owners