Configure computers and accounts

For the purpose of this integration, a remote Windows server was used to deploy the MS SQL database engine. A Windows PC was used as a client. A test database was created to show the encryption. Windows authentication is used for added security.

Join the domain

Both the Windows PC (client) and the remote Windows server must join the same Windows domain.

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