IT Connect

Information technology tools and resources at the UW

Enable Encryption

Encryption is the scrambling of data so only the intended users can read and understand the encrypted information. Encrypting the SQL connection to data on the Enterprise Data Warehouse is very important. Without encryption the data sent between the server and the client is readable by anyone that can intercept your network packet.  If you access confidential data, it is considered a basic security practice to encrypt the communications between you and the server.

How to Enable Encryption:

For SQL Server

Enabling Encryption For SSMS (SQL Server Mgmt Studio) Connections

The first two screens show how to find the encrypt connection setting when you simply open a new connection in SSMS.  The third screen shows where it is if you use “registered servers” in SSMS.

click options

check encrypt connection

Enabling Encryption for ODBC (Microsoft Access) Connections

This screen shows the box to check when setting up one’s ODBC connection.  You can find complete instructions on creating an ODBC connection here.

check use strong encryption for data

For Business Intelligence Development Studio (BIDS)

From within BIDS, double-click on a Shared Data Source object.

click edit

click advanced

set Encrypt to true under Security

addition of ;Encrypt=True at the end of the connection string

The outcome is the addition of ;Encrypt=True at the end of the connection string.  You could also hand-type that without having to click through the screens.