DataVeil home

Home    Table of Contents

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:

DataVeil SQL Server connection form

 

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.

Authentication

Windows

Windows Authentication shall be used.

SQL Server

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.

Instance

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.

Port

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.

 

Home    Table of Contents