Site Map

Data Masker is the easiest to use and most cost effective SQL Server data scrambling tool available.

 

KEY FEATURES


Key Features Icon

KEY FEATURES

A summary of the Data Masker software.

 

WHITE PAPERS


White Paper Icon

DATA MASKING: WHAT YOU NEED TO KNOW

A comprehensive survey of the techniques and issues you need to know about before you begin data masking.

 

DOWNLOAD


Download Icon

DOWNLOAD DATA MASKER

A 30 day, fully functional, evaluation copy of the Data Masker software.

 

DOCUMENTATION


Quick Start Icon

QUICK START

A Quick start to the Data Masker software.

FAQ Icon

DATA MASKER FAQ

Answers to frequently asked questions about the Data Masker software.

System Reqirements Icon

SYSTEM REQUIREMENTS

The hardware & software supported by Data Masker.

 

A Note on Using Visual Studio 2005 to Connect to SQL Servers by Name

 

Anthony Z. sends us this information regarding a feature you may run across when connecting to SQL Servers out of the .NET 2005 development environment. We have not tested this yet - but thought we would pass on the advice.

  • Regardless of the fact that .NET 2005 development environment shows SQL Servers by name one needs to use an IP address and port number of a computer where SQL Server 2005 Express is installed to get connected to the server

  • The connection string should be created in the following way:

string connString = "server=192.168.0.36, 1030; Integrated Security=True; Initial Catalog=my_data_base; User ID=my_user_id; Password=my_pwd"

 

Notes:

  • Integrated Security=True This is a must since we need to let SQL Server know that we use Windows authentication
  • server=192.168.0.36, 1030 Port number (in the example below it is 1030) should be retrieved from the properties of TCP/IP protocol (see example of the TCP properties where the port is 1066).
  • It should also be noted that the port number can be set to be randomly assigned value by a Browser service when it gets started.

 

 

[ <<<Main Page >>> ]