Solution by SANJUKTA SAMON, iCreate Softwares:

To connect the SQL server database with an instance name, incorporate the below in the web.xml file,

<!-- Connection String For SQL Server -->
<param-value>Provider=Mondrian;Jdbc=jdbc:sqlserver://\saba_devl_vyasa_bizscore;jdbc.instanceN ame=ads;jdbc.username=sa;jdbc.password=Welcome1;Jd iver;Catalog=/WEB-INF/schema/bizscore.xml;</param-value>

The ads in the above string needs to be changed with the required instance name. The back-slash before the database name is very important. A forward slash will cause the connection to fail invoking unknown host exception.