Create and Deploy a Microsoft SQL Server datasource
Then create a text file in the deploy directory called mssql-ds.xml with the following datasource descriptor : DefaultDS jdbc:sqlserver://localhost:1433;DatabaseName=pubs com.microsoft.sqlserver.jdbc.SQLServerDriver sa jboss SELECT 1 FROM sysobjects MS SQLSERVER2000 The datasource is pointing at a database pubs provided by default with MS SQL Server 2000. Remember to update the connection url attributes as well as the username/password combination to match your environment setup.