This portal-sqlserver-ds.xml is right?
The 192.168.25.23 is a remote database.
<?xml version="1.0" encoding="UTF-8"?> <datasources> <local-tx-datasource> <jndi-name>MSSQLDS</jndi-name> <connection-url>jdbc:microsoft:sqlserver://192.168.25.23:1433;databaseName=bts</connection-url> <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class> <driver-class>com.microsoft.jdbc.base.BaseDriver</driver-class> <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class> <user-name>HFDEV</user-name> <password>HFDEV</password> <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) --> <metadata> <type-mapping>MS SQLSERVER2000</type-mapping> </metadata> </local-tx-datasource> </datasources>