SQLServer IntegratedSecurity related

gthoppae.gmail.com's picture
Hi all, I have a problem trying to create a data service under WSAS 3.1.3 running on my desktop (Windows Vista). I would like to connect to the MSSQLserver using the windows native authentication. Here is the jdbc string: jdbc:sqlserver://teraclope\chiefmaster:1592;databaseName=EhlStages;Provider=SQLOLEDB.1; I placed the sqljdbc4 jar in WSAS_ROOT\repository\components as well as in WSAS_ROOT\repository\lib directories. I also placed sqljdbc_auth.dll in (JAVA_HOME\bin). As the username, password is assumed to be supplied automatically by the sqljdbc_auth.dll these params can only be empty. My dbs config file looks like this:     <config id="ehlstages">         <property name="org.wso2.ws.dataservice.driver">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>         <property name="org.wso2.ws.dataservice.protocol">jdbc:sqlserver://teraclope\chiefmaster:1592;databaseName=EhlStages;Provider=SQLOLEDB.1;IntegratedSecurity=true;</property>         <property name="org.wso2.ws.dataservice.user"/>         <property name="org.wso2.ws.dataservice.password"/>         <property name="org.wso2.ws.dataservice.minpoolsize">1</property>         <property name="org.wso2.ws.dataservice.maxpoolsize">1</property>         <property name="org.wso2.ws.dataservice.autocommit">true</property>     </config> FYI, the above jdbc connect string has been in production in one of our java based ESB environment. My questions:   1. Has the MSSQLserver been tested with IntegratedSecurity option ?   2. Keeping the org.wso2.ws.dataservice.user, org.wso2.ws.dataservice.password empty results in appending empty strings ? Any suggestions for progressing forward will be much appreciated! Thanks Regards Gnana
jr97's picture

The driver should go in the

The driver should go in the WSAS_ROOT\repository\components\extensions\ directory. I"ve never had luck connecting with windows native authentication. Things work great with SQL Server level access though. I also use the jtds driver instead of the ms jdbc driver. I've never been able to get the ms driver to work.
library project main code
Learn Cloud
Learn
Cloud

The WSO2 Application Server is a reliable application server that can host your enterprise web applications. The WSO2 Application Server as a Service is offered in StratosLive, the WSO2 Platform as a Service. This article explains how a simple web application can be developed and deployed from Carbon Studio to the WSO2 Application Server...

Latest Webinar
Different groups within an organization need to monitor different Key Performance Indicators (KPIs) - An operations team will be interested in the response times of business services and loads of each service,..
Thursday, February 9th 2012, 09.00 AM (PST)

Thursday, February 9th 2012, 10.00 AM (GMT)