Encrypted connection to SQl Server 2005

• 
  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 D October 02, 2009 08:07

  - 0 +

Add comment

Please sign in to leave a comment.