AquaLogic Collaboration DB connection fail with SQL Server

If you are using SQL Server as a backend for AquaLogic or Plumtree, it's diagnostic test will be fail due to schema name mismatch in configuration file and SQL Server's schema name for the Collaboration DB. To correct this problem, we need to edit the database.xml files by following steps,

- find database.xml files on AquaLogic installation directory [eg. C:\bea]

- change DB_ali_Name.DB_User_Name.'s [DB_User_Name] to [dbo]

After that diagnostic should be success as well as system will work fine. Don’t forget to restart services after xml file changes.