首先把sql server jdbc driver copy \common\lib下
我刚配上的如下:
-----------------------------------------------------------------------mssql-ds.xml
<datasources>
  <local-tx-datasource>
    <jndi-name>jdbc/test</jndi-name>
    <connection-url>jdbc:microsoft:sqlserver://10.1.1.192:1433;DatabaseName=TEST</connection-url>
    <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
    <user-name>sa</user-name>
    <password>sa</password>
  </local-tx-datasource></datasources>
-----------------------------------------------------------------------standardjbosscmp-jdbc.xml
      <datasource>java:/jdbc/test</datasource>
      <datasource-mapping>MS SQLSERVER2000</datasource-mapping>
-----------------------------------------------------------------------
standardjaws.xml
   <datasource>java:/jdbc/test</datasource>
   <type-mapping>MS SQLSERVER2000</type-mapping>
   <debug>false</debug>
测试:<%@page language="java"  contentType="text/html;"%>
<%@page import="java.sql.*,javax.naming.Context,javax.naming.InitialContext"%>
<%@page import="javax.sql.DataSource"%>
<%
Connection conn    = null;
Statement  stmt    = null;
ResultSet  rs      = null;
try {
Context    initCtx = new InitialContext();
DataSource ds  = (DataSource)initCtx.lookup("java:/jdbc/test"); 
         conn  = ds.getConnection();
if (conn != null)
out.println("ok");
else
out.println("error");
} catch(Exception ex) {
out.println(ex.getMessage());
} finally {
if (conn != null) conn.close();
}  
%>