cancel
Showing results for 
Search instead for 
Did you mean: 

How my clients are connected? Used plain text or encrypted passwords?

0 Kudos

Hi,

We know that ASE supports encrypted password transmission over the network from clients.

Is there any way to know within the server how my clients transmitted the password during logon? Did they transmitted the plain password or encrypted password?


Before changing the configuration value to 1 for net password encryption required I want to make sure that all current clients are connecting with encrypted password.

Naveen.

0 Kudos

This option is not useful as auditing is not enabled on our servers.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Naveen,

ProActive DBA Database Auditor has a report that identifies if the login was made using an encrypted password (or not). It also identifies the specific client library used, TCP/IP and port number of the source connection, etc.  The data is obtained non-intrusively and doesn't require using any DBCC commands or the MDA tables.

Please visit this site for more information:

http://www.proactivedba.com/database-auditor

Thanks,

David L. Cherin

former_member188958
Active Contributor
0 Kudos

Please see my blog entry

0 Kudos

Hi Bret,

Thanks for your details.

I have looked at your blog. But unfortunately we cannot run these commands in production environmnet as these are not supported/ documented. Additionally only DBA can run them but not normal users.

Is there any flag/ bit with system tables like sysprocess and all users can access?

Regards,

Naveen.