Database Connection Encryption

Database Connection Encryption

  
Hello everyone out there,

I have created a Database Connection at the Service Center in order to access an external database's data. The connection DBMS is to SQL Server. Integrated Security is not used.
My question is, is this connection encrypted (especially the credentials)?

Thanks in advance

Best Regards,


Marios
Hello Marios

That's a good question! :) 

I've searched the MSDn documentation at a glance, and could not find information if the default connection encrypts the credentials. I suspect that there must be a handshake of some sort for SQL Server type of login.

Nevertheless, activating the SQL Server Connection encryption should do the trick, and since it's done at the SQL Client, it should be rather easy.

Here's some Microsoft articles about it:

http://msdn.microsoft.com/en-us/library/ms191192.aspx
http://msdn.microsoft.com/en-us/library/ms189067.aspx

Hope this helps.

Cheers

Miguel Simões João