Thanks Jaikiran for your reply again but in the mssql-ds.xml I have specified the different jndi name for both the Ears. My mssql-ds.xml looks like this:- Best Regards, Rahul Soni. | <?xml version="1.0" encoding="UTF-8"?> | <datasources> | <local-tx-datasource> | <jndi-name>jdbc/Northwind1</jndi-name> | <connection-url>jdbc:sqlserver://localhost:1433;DatabaseName=Northwind;</connection-url> | <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class> | <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> | <user-name>xx</user-name> | <password>xxxx</password> | <min-pool-size>3</min-pool-size> | <max-pool-size>200</max-pool-size> | <prepared-statement-cache-size>50</prepared-statement-cache-size> | </local-tx-datasource> | <local-tx-datasource> | <jndi-name>jdbc/Northwind2</jndi-name> | <connection-url>jdbc:sqlserver://localhost:1433;DatabaseName=Northwind;</connection-url> | <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class> | <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> | <user-name>xx</user-name> | <password>xxxx</password> | <min-pool-size>3</min-pool-size> | <max-pool-size>200</max-pool-size> | <prepared-statement-cache-size>50</prepared-statement-cache-size> | </local-tx-datasource> | </datasources> | | View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4149727#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...