SQL Error 18456 when adding SQL DB to vCO/vRO vRealize Orchestrator inventory

Are you having trouble adding an MS SQL DB to the vCO/vRO vRealize Orchestrator inventory?
Are you getting Event 18456 in the Application log of the SQL server?
It might look like this;
Login failed for user 'administrator'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 192.168.157.1]

This will most likely be because you need to add ";domain=<AD domain name, or SQL server hostname if using a local account>" to the of your JDBC connection URL

i.e.

Connection URL:             jdbc:jtds:sqlserver://sql01:1433/Database01;domain=sql01

For more info, see 

http://itsgettingcloudy.blogspot.co.uk/2015/05/adding-sql-2012-r2-database-to-vrealize.html