Encrypted connection to SQl Server 2005

desbutcher · September 29, 2009 3:48AM

Hi,
we enforce encryption when connecting from SQL Server Management studio to our SQl Server 2005 databases. Does SQL compare 8 support encrypted connections, if so would you let know how to configure it?

Thanks,

Des.|

Eddie D · October 2, 2009 8:07AM

As per the support call created for you.

By default SQL Compare does not have option to encrypt the connection string.

When you start up SQL Compare, Project Configuration - Data Sources Tab.

Enter the server name, you could try entering the following to force an encrypted connection:

Default Instance

<Server Name>;ENCRYPT=TRUE;TRUSTSERVERCERTIFICATE=TRUE

Named Instance

<Server Name>\<Instance Name>;ENCRYPT=TRUE;TRUSTSERVERCERTIFICATE=TRUE

Or if server is not running on the default SQL Port 1433,

<Server Name>,<port number>;ENCRYPT=TRUE;TRUSTSERVERCERTIFICATE=TRUE

<Server Name>\<Instance Name>,<port number>;ENCRYPT=TRUE;TRUSTSERVERCERTIFICATE=TRUE

Many Thanks
Eddie

Encrypted connection to SQl Server 2005

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk