Database connection to SQl Server 2008 R2
Hi All, I have imported sqljdbc4.2 jars in Soapui lib directory and using groovy want to connect to SQL Server 2008 R2 Edition with windows authentication.Please find the below code for and c...
Forum Discussion
Hi Niyaz,
Just a quick note and sorry if you have already tried this, but where you say that you have added the SQL Server jar to the SoapUI lib folder, do you mean as in <SoapUI Home>/lib folder? As this might work, but the normal way to add external libraries is actually to add them to <SoapUI Home>/bin/ext (you will see a readme file in here saying this). If the jar file is added to the bin/ext folder then you can check to see an info message in the SoapUI log saying whether the jar file has actually been added, if there is none it hasn't.
Possibly the lib folder is equivalent, maybe a different classpath, but I just wanted to check in case it helps.
Cheers,
Rupert
Hi Rupert,
I have added jars into /bin/ext directory too. Now, I am getting login failed for user username while connecting to the database.The authentication mode in SQL Server is mixed mode only.Please help me in resolving this issue.Waiting for your reply.
Regards,
Niyaz
Hi Niyaz,
Ok good, it sounds like you have fixed the class load issue, which is something.
Unfortunately, my experience of SQL Server is very old and I don't have a windows machine to install it on.
Can any Windows/SQL Server users help Niyaz get the authentication sorted out please?
Sorry not to be of more help,
Cheers,
Rup
Hi All,
I am still waiting for the reply.
Regards,
Niyaz
