cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Database configuration

Highlighted
Occasional Contributor

SQL Database configuration

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  the jdbc driver , that i am using,   supports only the SQL User.

 

Regards

Enkeleda Sinani

 

 

 

3 REPLIES 3
Highlighted
Super Contributor

Re: SQL Database configuration

Here is the ReadyAPI documentation for configuring windows authentication for SQL Server JDBC drivers:

 

https://support.smartbear.com/readyapi/docs/testing/data-driven/drivers/install/mssql.html#configuri...

Highlighted
Occasional Contributor

Re: SQL Database configuration

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.

 

Regards

 

Highlighted
Community Hero

Re: SQL Database configuration

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?

Ta

Richie
if this helped answer the post, could you please mark it as 'solved'? Also if you consider whether the title of your post is relevant? Perhaps if the post is solved, it might make sense to update the Subject header field of the post to something more descriptive? This will help people when searching for problems. Ta
New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors