I am trying to access MS SQL tables from BI wizard through VC.
I created a BIUDDI JDBC SQL system, the test connection has failed, but the normal JDBC system is working fine.
Is there any additional settings do I need to do in J2EE connector service as specified in the document (How configure BI JDBC System.pdf).
The following properties I filled in the connection, I done user mapping also.
<b>Field Catalog:</b> Northwind
<b>Field Schema :</b> dbo
Can you please give me a suggestion to get it done.