on 06-30-2014 2:47 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.