How PPM checks a password on an SQL system (4226792)

How PPM checks a password on an SQL system

Please provide a description of the actions taken by PAR when performing a password check on MSSQL Databases. We ask because some of our DB folks advised that using the syslogin view was deprecated after sql 2005.

PPM opens a connection to the database server using the username/password of the account being checked. If the connection can be established, the test is successful. If not, PPM then connects to the database using the functional account and queries master..syslogins for the existence of the account. If the account exists, it is reported that there is a password mismatch, if it does not, the error indicates that the account does not exist, and if this connection cannot be established, then an “unable to connect” message is returned.