ODBC Security

[MAK]

Hi Guys.

If I create a SYSTEM DSN ODBC for SQL Server 7.0 (3.70.09.61),
will the password be encrypted in standard 128 bit encryption?

I want to make sure that it is safe to use ODBC for SQL Server.
I found something on MS on Trace.... I am not sure whether it is applicable
for ODBC 3 or more.

Any related docs or urls for this?

Any comments and suggestion are always welcome.
-MAK

[TimH]

Mak,

Try the following links:

(A) ODBC Trace for ODBC v3.0
http://support.microsoft.com/support/kb/articles/Q168/8/79.asp?LN=EN-GB&SD=gn&FR=0

(B) Enable Multiprotocol encryption by doing the following:

How to enable encryption after SQL Server has been installed
To set up encryption

1) On the Start menu, point to Programs/Microsoft SQL Server 7.0, and then click Server Network Utility.

2) On the General tab of the SQL Server Network Utility dialog box, if Multiprotocol does not appear in the Server network library list, click Add. Otherwise, skip to Step 5.

3) In the Add Network Library Configuration dialog box, select Multiprotocol from the Network libraries list.
4) Select Enable multi-protocol encryption.

5) If you already have a multiprotocol server network library installed, select Multiprotocol from the Server network library list on the General tab, and click Edit.

6) In the Edit Network Library Configuration dialog box, select Enable multi-protocol encryption.


Hope this helps,

Tim


------------
MAK at 3/22/01 4:16:47 PM

Hi Guys.

If I create a SYSTEM DSN ODBC for SQL Server 7.0 (3.70.09.61),
will the password be encrypted in standard 128 bit encryption?

I want to make sure that it is safe to use ODBC for SQL Server.
I found something on MS on Trace.... I am not sure whether it is applicable
for ODBC 3 or more.

Any related docs or urls for this?

Any comments and suggestion are always welcome.
-MAK