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 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
- May be error code might help better. See the connection strings
https://www.connectionstrings.com/sql-server-2008/Hi All,
I am getting Login failed for user username.I had copied jars into lib folder.Please find the below code:
import groovy.sql.Sql
try{
def dbURL = "jdbc:sqlserver://servername:1433"
def dbUsername = 'username'
def dbPassword = 'password'
def dbDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"
def sql = Sql.newInstance(dbURL,dbUsername,dbPassword,dbDriver)log.info "Connected to database successfully"
}catch(Exception e){
log.info "Database error"
log.info e.getMessage()
}Regards,
Niyaz
Niyaz,
I meant that you can verify the right connection string that suits your needs and revert with the response code of sql error while connection.
Unfortunately, I do not use sql server.
