ReportServer Forum

bhutan

Member

Registered: 2020-05-07

Relational Database: Connect to Microsoft SQL Server : URL

What is the format for URL for Relational Database to Connect to Microsoft SQL Server? My remote database server IP is 192.168.1.11 and the port is 1433. Thanks.

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Relational Database: Connect to Microsoft SQL Server : URL

Hi bhutan,

please check the documentation on mssql jdbc connection url here: https://docs.microsoft.com/en-us/sql/co … rver-ver15
You have to add your driver (e.g. sqljdbc42.jar ) to WEB-INF/classes or to your external config directory if you configured one.

Regards,
Eduardo

bhutan

Member

Registered: 2020-05-07

Re: Relational Database: Connect to Microsoft SQL Server : URL

Thank you eduardo.