Search code examples
sqldreamweaverpassword-encryption

encrypt password - Connect Dreamweaver to SQL server databse


I am trying to set a connection between Dreamweaver and Sql server database, i am using the wizard under Dreamweaver CS3
the wizard creates a file named connections and inside that file i have

<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_Q_S_Conn_STRING

MM_Q_S_Conn_STRING = "Driver={SQL Server};ServeR=\SQL08R2T_INST4;Database=XTEST;Uid=                TDWEAVER;Pwd=tdweaver;"
%>


all is working fine and i can access the database and add/delete/update records

The administrator is asking to apply encryption to the password and send him the way the encryption is performed

Can i add encryption to the password inside the Connection String? or maybe add encryption type ? Any help please

Solution

  • My first question would be: Does the driver encrypt the connection to the database? If not, then what's the point of encrypting the password when the first connection publishes it as plain text on the local network?

    The next question: Why can anyone read the file? If only the process can read the file, what additional security does encrypting the password provide?

    For me, this feels like security by obscurity which is a valid security layer if you have covered all the other bases. If you didn't, then it's just a waste of time.