Site Map

Data Masker is the easiest to use and most cost effective SQL Server data anonymization 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.

 

Enabling the TCP/IP protocol in the SQL Server Configuration Utility to Configure SQL Server Express 2005 for Remote Access

 

 

 

On the IP Addresses tab you will probably see several sections - one for each network connection. In the example below there is only one network card (listed in the first section) and a local loopback connection indicated by the standard address of 127.0.0.1 For remote access to the SQL Server Express 2005 instance the loopback connection is of no interest.

The first section is where the configuration has to be correct. Active option should say Yes as should the Enabled option. The IP address will probably be filled in for you (by Windows) and will be different on your machine.

If you wish to enable dynamic ports for your SQL Server Express 2005 instance then the TCP Dynamic Ports option should be 0. To disable this option and use a fixed port change this field to a blank value and fill in the port on the TCP Port option. Disabling dynamic ports is non standard for named instances and should really only be done if you know exactly what you are doing and why you want to do it.

Note: Dynamic ports means that the SQL Server Express 2005 instance gets assigned a random port every time it is started up. In order to connect, the remote client needs to know this port. It asks the Server Browser for the port number (the Server Browser has a well known and unchanging port configuration so it can always be found). The upshot is that if dynamic ports are used then the Server Browser must be started. Enabling the Server Browser is the topic for another page in this series.

 

 

[ <<<Start Page >>> ]