You must Sign In to post a response.
  • Category: SQL Server

    Bulk deployment of SSRS reports

    How to deploy SSRS reports by using SQL server data tools. I have tried it, but it shows syntax for the URL is incorrect. Can anyone explain it with screenshot.
  • #765365
    The easiest way to publish and manage reports is with the built-in Report Manager. This is also called Native Mode deployment. Report Manager is a small web site that can run on a separate web server or on the SQL Server that is hosting the SSRS databases. Starting with 2008, SSRS is not dependent on Internet Information Services (IIS) which makes DBAs more comfortable deploying it on the same server as the database engine.
    see below steps
    here
    https://www.simple-talk.com/sql/reporting-services/sql-server-reporting-services-basics-deploying-reports/
    OR
    http://www.sqlcircuit.com/2012/11/ssrs-different-ways-of-deploying-reports.html

    Thanks
    Koolprasd2003
    Editor, DotNetSpider MVM
    Microsoft MVP 2014 [ASP.NET/IIS]


Sign In to post your comments