SQL Database configuration

Question

I am trying to configure the sql database connection using MSSQL(MicrosoftDriver)/com.microsoft.sqlserver.jdbc.SQLServerDriver
If I try connectiong using the Sql user the connection is completed succecfully, but due to some internal auditing policies i am oblieged to use the windows authentication user.
It seems that the jdbc driver does not support the windows authentication user.
Please support me on this matter, as i need to find a solution that includes using a windows authentication or if not, please confirm me that&nbsp; the jdbc driver , that i am using, &nbsp; supports only the SQL User.
&nbsp;
Regards
Enkeleda Sinani
&nbsp;
&nbsp;
&nbsp;

radford · Answer

Here is the ReadyAPI documentation for configuring windows authentication for SQL Server JDBC drivers:
&nbsp;
https://support.smartbear.com/readyapi/docs/testing/data-driven/drivers/install/mssql.html#configuring-ntlm

enkeleda2006 · Answer

I followed instruction and now i have a message error as below;
Can't get the Connection for specified properties; com.microsoft.sqlserver.jdbc.SQLServerException. The connection string contains a badly formed name or value.
&nbsp;
Regards
&nbsp;

richie · Answer

Hi,I had loads of trouble with this about 3 months ago.  I'm on holiday at moment so i didnt bring my laptop, so i cant remembet how i got around this, but did you try the jndi driver?TaRichie

Forum Discussion

SQL Database configuration

3 Replies

Related Content

[Solved] [JDBC] Cannot connect to a MS SQL database

TestComplete and SQL databases - Restoring per test

Edit Database table checkpoint SQL

Data Import from SQL Database

MSTest Configuration

Recent Discussions

GroovyScript Help - Repeating JSON Attributes Have Specific Value.....some of the time?

Test Runner - Report All in One File

Parameterising JDBC Connection Settings..Can you do it?

JDBC results are stored in the ReadyAPI project

MyFirstPlugin - button Project menu in Ready Api