In CCA, when attempting to discover the SQL Server using the MS SQL Server blueprint, you may encounter one (or more) of the following errors:
The database blueprint discovered the installed application and its configuration files, but not the database data.
The blueprint does 2 things:
1 - Attempts to find the application and its installed path and from there gather configuration information (by files or commands)
2 - Attempts to connect to the database itself using the specified credentials in the blueprint
Now, the best practice for this is NOT to put the username and password in the blueprint; you want to keep it standard. What you would do is discover the blueprint (as it seems you did), then go into that server(s) --> components, and select that discovered blueprint. Within there, you can go to "Component Parameters and Variables" --> "User Input" and fill out the username\password here
From here, in the components screen, checkbox that component and do "Select Actions" --> Run Discover. The rediscover should pick up the actual database data
This allows for each server to have a specific credential (incase each database instance has a different set of user\pass) and keeps the blueprint generic. The only time to modify the original blueprint is if every single database login uses the same username and pass. If the later, then no need to run a rediscovery in components, the OOTB with User\Pass should work