[Help] - How to connect with MsSQL database

ReportServer (EN)
1

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.

2

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.

3

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,

4

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/library/ms378428(v=sql.105).aspx
https://technet.microsoft.com/en-us/library/ms378988(v=sql.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.

5

Hi friend - I got error “No database type specified”

6

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