I wish to know whether or not by default MS SQL Server 2005 Std or Ent edition will encrypt the communication over the network by default?
As, when we test out the database activity monitoring solution to capture the SQL traffics from the network, we are unable to see the DB user name and Source Program but SQL statements is able to seen. According to the vendor, it is due to the nature of
MS SQL Server 2005 that encrypt the communication by default. But, why is it only encrypted the DB user name and Source Program but not the SQL statement?
Can someone provide me the answer? Is that true what the vendor claims?
View Complete Post