Bug 1951342

The SQL Server metrics in PCP require authentication to access the database to extract metrics.  To set ourselves up for success in more situations, we could make use of the username/password available from the filesystem setup for the SQL Server Assessment API as (planned to be) used by Insights.

Some notes from SQL Server google chat room follow.


Louis Imershein> @Nathan Scott one improvement to PCP might be to teach it to use the same password file as the assessment API
We're still finalizing the file name but a user name and password will be in /var/opt/mssql/secrets/ - accessing it will require either root or the mssql user account for security purposes.  Permissions on the file will be 0600.

Nathan Scott> @Louis Imershein definitely - what will the file names and file formats be in that secrets directory?

Louis Imershein> assuming it's like the ha file, it will just be a username separated from a password by a newline
as soon as i know the file name i will share it with you

Nathan Scott> too easy - I'll open an RFE BZ to get PCP updated

Louis Imershein> Let's make sure Insights team as well as @Brian Smith and @Karl Abbott are aware of our plan, but I think this makes the most sense.
I want something more secure, like principals that automatically authenticate to AD at startup via protected credentials but we need a solution for that for several areas with SQL Server.  At least this in no way adds to the problems in that dept, in fact it's arguably better than some of the other options.