Configure computers and accounts

For this integration, the Microsoft SQL Server Database Engine was deployed on a remote Windows server, and a Windows PC served as the client. Both systems were joined to the same Windows domain, and Windows authentication was used for additional security. A test database was created to demonstrate data encryption.

Create domain accounts

Create two Windows domain accounts. For example:

  • <domain>\dbuser

  • <domain>\dbuser2

Allow domain accounts to remote login

  1. In the Windows PC (client), enter advance settings in the search box and select View advanced system settings.

  2. Select the Remote tab in the System Properties dialog. Then select Select Users…​.

  3. Add the following users:

    • <domain>\dbuser

    • <domain>\dbuser2

    remote users

Install SSMS in client

Install Microsoft SQL Server Management Studio in the Windows PC (client).

Install the SQL database engine in remote Windows server

  1. Install the SQL engine in the remote Windows server.

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

Create a test database

A test database named TestDatabase was created. You can use your own database instead.

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 of the two SQL logins as database owners, db_owner, of TestDatabase.

    testdatabase owners