Encrypted connection to SQl Server 2005

desbutcherdesbutcher Posts: 2
edited October 2, 2009 8:07AM in SQL Compare Previous Versions
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.|

Comments

  • Eddie DEddie D Posts: 1,681 Rose Gold 5
    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
    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.