connecting to sql server
I am very new to using SOAP UI tool by practising i have got some idea.. now i want to get somemore idea about how to connect to my sql server from my soapui tool can anyone help me about this...
Forum Discussion
hi,
I have been trying to connect to sql server from soapui pro 3.6.1 with no success. Here are the details
Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
connection string : jdbc:sqlserver://127.0.0.1:1433;databaseName=dbname;user=username;password=PASS_VALUE;
sqljdbc jar file is in: C:\Program Files\eviware\soapUI-Pro-3.6.1\bin\ext
I also downloaded sqljdbc4.jar and placed in the same folder
I am getting following error:
Can't get the Connection for specified properties; com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'username'.
However I am able to connect to the database using same username/password via management studio. No idea whats going wrong. Also checked the authentication mode which is Mixed(Windows and SQL), the login is enabled as well.
Every help is appreciated.
Thanks.
I have been trying to connect to sql server from soapui pro 3.6.1 with no success. Here are the details
Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
connection string : jdbc:sqlserver://127.0.0.1:1433;databaseName=dbname;user=username;password=PASS_VALUE;
sqljdbc jar file is in: C:\Program Files\eviware\soapUI-Pro-3.6.1\bin\ext
I also downloaded sqljdbc4.jar and placed in the same folder
I am getting following error:
Can't get the Connection for specified properties; com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'username'.
However I am able to connect to the database using same username/password via management studio. No idea whats going wrong. Also checked the authentication mode which is Mixed(Windows and SQL), the login is enabled as well.
Every help is appreciated.
Thanks.