Connection String for SQL DB Scan - Unable to retrieve the list of table names
We are trying to find the correct Connection String to scan our SQL databases. I've read the previous discussions and tried all the connection string I could find to no avail.
Please take a look at this and let me know any suggesstions for other things to try. Also, are there specific database permissions we should set up.
We are getting the error:
"Failed to read sqlserver://hpsqld04.mycompany.com:1433/SecAdmin_Test;instance=mssqlserver; error: Unable to retrieve the list of table names: null"
Under the Scanned Content Tab, Scan Database Servers: Connection Strings we've tried (all get the same error):
Use These Credentials: UserName: mycompany\svcDLPuser -- database permission System Administrator