Test database

Microsoft SQL Server was deployed as a stand-alone instance on a single machine. A database named TestDatabase was created for the purpose of this integration. The following SQL query creates TestDatabase and displays a view of TestTable.

USE master
GO

-- Create database named "TestDatabase".
CREATE DATABASE TestDatabase;
GO

-- Create table named "TestTable" and populate it with some values.
USE TestDatabase
GO
CREATE TABLE TestTable (FirstName varchar(50), LastName varchar(50), Email varchar(320), Password nvarchar(50));
GO
INSERT INTO TestTable (FirstName, LastName, Email, Password) VALUES ('Firstname1', 'Lastname1', 'Firstname1.Lastname1@testserver.com', 'Paswword1');
INSERT INTO TestTable (FirstName, LastName, Email, Password) VALUES ('Firstname2', 'Lastname2', 'Firstname2.Lastname2@testserver.com', 'Paswword2');
INSERT INTO TestTable (FirstName, LastName, Email, Password) VALUES ('Firstname3', 'Lastname3', 'Firstname3.Lastname3@testserver.com', 'Paswword3');
INSERT INTO TestTable (FirstName, LastName, Email, Password) VALUES ('Firstname4', 'Lastname4', 'Firstname4.Lastname4@testserver.com', 'Paswword4');
INSERT INTO TestTable (FirstName, LastName, Email, Password) VALUES ('Firstname5', 'Lastname5', 'Firstname5.Lastname5@testserver.com', 'Paswword5');
GO

--Grants permissions to <DOMAIN>/Administrator.
USE TestDatabase;
GRANT ALTER ANY COLUMN ENCRYPTION KEY TO "INTEROP\Administrator";
GRANT ALTER ANY COLUMN MASTER KEY TO "INTEROP\Administrator";
GRANT VIEW ANY COLUMN ENCRYPTION KEY DEFINITION TO "INTEROP\Administrator";
GRANT VIEW ANY COLUMN MASTER KEY DEFINITION TO "INTEROP\Administrator";
GO
test database