I’m trying to troubleshoot why my MDT deployment can’t connect to the SQL server to query some info during deployment.
So I have my ZTIGather.log file. And in it there is
OPENING STANDARD SECURITY SQL CONNECTION to server WMTI-702 using login mdtsa. ZTIGather 8/9/2021 4:47:48 PM 0 (0x0000)
<Message containing password has been suppressed> ZTIGather 8/9/2021 4:47:48 PM 0 (0x0000)
ZTI error opening SQL Connection: Invalid connection string attribute (-2147467259) ZTIGather 8/9/2021 4:47:48 PM 0 (0x0000)
Unable to establish database connection using [SELECTABLEROLES] properties. ZTIGather 8/9/2021 4:47:48 PM 0 (0x0000)
This is printed around line 432 in ZTIDataAccess.vbs. I need to see the SQL query string to see what about it was invalid, but it’s being supressed because it contains a password.
How can I allow passwords to print in the logs so I can see the error?
