How to create Data Adapter in Jasper studio for SQL Server

[santosh.audi19]

Hello All,

Which JDBC Driver should be selected for connecting to DB of SQL Server, where SQL Server has Local host,Port,Username and Password.

Regards,
Santosh

[santosh.audi19]

Hello All,

I got connected to the SQL Server. In studio under the Repository Window Create a new Data Adaptor and select the below
JDBC Driver as :- com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC URL:-  jdbc:sqlserver://localhost:<Port_Number>;databaseName=<Username>
Username :-
Password :-

Here local host would be like 172.xx.x.xx , portnumber = 4 digit number
I didn't installed any other JAR files , just i have put databaseName=<username>, It got connected.

Regards,
Santosh