ReportServer Forum

Phuong

Member

Registered: 2016-11-21

[Help] - How to connect with MsSQL database

Hi everyone -

I'm new with Reportserver. After installing community version, i dont know how to install driver missing for mssql database & how to connect mssql datasource ?

Please support. Thanks in advance.

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: [Help] - How to connect with MsSQL database

Hi Phuong,

you can just copy the mssql driver to the WEB-INF/lib directory, restart reportserver, and then you can create a datasource selecting the sqlserver driver from the dropdown menu.

Phuong

Member

Registered: 2016-11-21

Re: [Help] - How to connect with MsSQL database

Hi Edulid - Following by your guidance, i can select MsSQL as a datasource type, but i dont know how to do next because i don't see detail info such as : sql server name (sql address IP), data base name , etc ... Just see Username, Password & URL. Where can I put this info ?  Could you please help ?

Thank you,

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: [Help] - How to connect with MsSQL database

Hi Phuong,

since reportserver uses JDBC, you can pass these parameters in the url.
Details can be found here:
https://technet.microsoft.com/en-us/lib … .105).aspx
https://technet.microsoft.com/en-us/lib … .105).aspx

An example url could be:
jdbc:sqlserver://ip;databaseName=db

Even if you can write your username and password in the URL, you should write them in the specified fields, since reportserver sometimes use these values explicitly.

Phuong

Member

Registered: 2016-11-21

Re: [Help] - How to connect with MsSQL database

Hi friend - I got error "No database type specified"

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: [Help] - How to connect with MsSQL database

Are you sure you selected the MsSQL entry from the "database" dropdown menu list?
If you installed the driver correctly (as I explained above) you should see the MsSQL entry *without* the "(driver missing)" remark