Install a DataSource in the Java 2 Enterprise Manager (J2EE) Version 1.4

	DataSource	XADataSource
Step 1) Enter connection pool Name	Name: SqlServer Classname:* com.inet.tds.TdsDataSource	Name: SqlServer Classname: com.inet.tds.DTCDataSource
Step 2) Enter resource type.	Resource Type: javax.sql.DataSource Description: Local MS SQL Server	Resource Type: javax.sql.XADataSource Description: Local MS SQL Server
Step 3) Specify pool settings.	default settings	default settings
Step 4) Specify general settings.	default settings	default settings
Step 5) Add properties.	ServerName: LocalHost DatabaseName: master User: any Password: any	ServerName: LocalHost DatabaseName: master User: any Password: any

Select the node JDBC / Connection Pooling / SqlServer (or the name that you use for the datasource) Click the “Ping” button to verify that your connection settings are valid.
If an error occurs then look in the server.log for the underlying error. The ping command and the admin console does not work with an empty password. If you need an empty password then you can enter a password and change it to empty in the domain.xml file.
Add a new JDBC Resource

You might also want to visit