The moose likes JDBC and Relational Databases and the fly likes Configuring SQL Server 2008 to JBOSS Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Configuring SQL Server 2008 to JBOSS" Watch "Configuring SQL Server 2008 to JBOSS" New topic

Configuring SQL Server 2008 to JBOSS

Vikki Fiawoo

Joined: Oct 22, 2010
Posts: 11
Good Morning,

I am trying to run a simple jsp that will Sql Server 2008 connection using JBOSS 5.1 (Enterprise Application). Please find below the tutorial. It is under the section
Configuring a datasource for Microsoft SQL Server 200x


Here is how I modified the mssql-ds.xml file:

I placed this file in the C:\Program Files\EnterprisePlatform-5.1.0\jboss-eap-5.1\jboss-as\server\default\deploy folder.

2.) I copied the sqljdbc4.jar file in the C:\Program Files\EnterprisePlatform-5.1.0\jboss-eap-5.1\jboss-as\server\default\lib folder

3.) I created a WAR folder jdbcclient.war in the C:\Program Files\EnterprisePlatform-5.1.0\jboss-eap-5.1\jboss-as\server\default\deploy folder.

4.) I created a jsp called client.jsp and saved it in the jbdcclient.war folder. Here is the client.jsp code:

5. I tried to test if the connectioni using the following url


There are a few things I would like to mention. After reading some of the many posts in this forum on this topic, I have noticed that do not have sqljdbc_auth.dll file copied anywhere in JBOSS. So I only copied the path tot the sqljdbc_auth.dll to the Systems Variables PATH. Should this file be copied anywhere else? If so, where specifically where I copy the file.

Also, I am using a Window Authenciation to access the Sql Server database. I feel very strongly that my mssql-ds.xml file is not configured properly. I have tried modified this file several different ways and have read numerous documentation and still can not get this client.jsp to work.

I am just trying to test my connectivity from Sql Server to JBoss and this seems to be so difficult to do.

Please provide me with assistances on how to modified my files and/or where to copy any necessary jars. I have been on this for 12 hours and at this point I do not now what to do. I have also attached the error message I am receiving.
Madhan Sundararajan Devaki
Ranch Hand

Joined: Mar 18, 2011
Posts: 312

Please refer to,

Not many get the right opportunity !
I agree. Here's the link:
subject: Configuring SQL Server 2008 to JBOSS
jQuery in Action, 3rd edition