You are not logged in.
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.
Offline
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.
Online
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,
Offline
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.
Online
Hi friend - I got error "No database type specified"
Offline
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
Online