Connecting to SQL Server
DataVeil supports connections to SQL Server 2008 and later. DataVeil uses JDBC for connection.
The form displayed in the Connection window for SQL Server connections is shown below:
Please check with your DBA to ensure that the User that you login with has the required access and permissions. In order to Run DataVeil masking projects, the User must have broad DBA-level permissions. DataVeil needs to create and drop tables, indexes and alter triggers and constraints.
***Note: The TCP/IP protocol must be enabled on SQL Server
If you experience connection difficulties then please refer to the SQL Server connection troubleshooting guide.
Windows Authentication shall be used.
Connection authentication shall take place at SQL Server. You shall be prompted for a username and password.
Host or IP
This can be a server name (as shown in the example above), or an IP address, or blank.
If your database is on the same computer where DataVeil is run then you can leave this field blank.
This is the SQL Server instance to which you wish to connect. If a default instance has been configured then this field can be left blank.
The TCP port where the connection shall be attempted. If left blank then the SQL Server default port shall be attempted.
You can specify other execution parameters that apply to this connection such as masking batch sizes and the maximum number of parallel JDBC connections (threads). Please refer to Execution Settings for details.