title: jboss 7 AS datasource for sqlserver
body: <p>I run jboss in standalone mode and have set my datasource in the <code>standalone.xml</code> to the following:</p>
  
  <pre><code>&lt;datasource jndi-name="MyDenaliDS" pool-name="MyDenaliDs_Pool" enabled="true" jta="true" 
                                                     use-java-context="true" use-ccm="true"&gt;
      &lt;connection-url&gt;
          jdbc:sqlserver://myip:1433;databaseName=mydb;integratedSecurity=true
      &lt;/connection-url&gt;
      &lt;driver&gt;
          sqljdbc
      &lt;/driver&gt;
      &lt;security&gt;
          &lt;user-name&gt;
              username
          &lt;/user-name&gt;
          &lt;password&gt;
              password
          &lt;/password&gt;
      &lt;/security&gt;
  &lt;/datasource&gt;
  &lt;drivers&gt;
      &lt;driver name="sqljdbc" module="com.microsoft.sqlserver.jdbc"&gt;
          &lt;driver-class&gt;
              com.microsoft.sqlserver.jdbc.SQLServerDataSource
          &lt;/driver-class&gt;
      &lt;/driver&gt;                    
  &lt;/drivers&gt;
  </code></pre>
  
  <p>in the folder <code>%jbosshome%\modules\com\microsoft\sqlserver\jdbc\</code> I have the <code>sqljdb4.jar</code> and the following <code>module.xml</code>:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;module name="com.microsoft.sqlserver.jdbc" xmlns="urn:jboss:module:1.0"&gt;
      &lt;resources&gt;
          &lt;resource-root path="sqljdbc4.jar"/&gt; 
       &lt;/resources&gt;
       &lt;dependencies&gt;
          &lt;module name="javax.api"/&gt;
          &lt;module name="javax.transaction.api"/&gt; 
       &lt;/dependencies&gt;
  &lt;/module&gt;
  </code></pre>
  
  <p>When I start the jboss it gives me the following error:</p>
  
  <pre><code>&gt; New missing/unsatisfied dependencies:    service
  &gt; jboss.jdbc-driver.sqljdbc (missing)
  </code></pre>
  
  <p>Anyone know what I've done incorrect or what I'm missing?</p>