Sql-server – Installation of SSRS

sql serverssrsssrs-2016

I have a doubt regarding SSRS installation. I see two methods on the web.However I am not sure if both lead to same solution.

1)Install SSRS via installer OF SIZE 105 mb.

2)Install Visual Studio Community, then SSDT, which in turn installs SSRS, and post this install templates via VS extensions.

My question is whether both these methods lead to the same result? If not which is the correct one?

The requirement in m organisation is to develop SSRS reports using TSQL DYNAMIC QUERIES,FUNCTIONS,AND STORED PROCEDURES.

SERVER :SQL SERVER 2019 DEVELOPER EDITION

Best Answer

I think you are possibly confusing two different but related items. The first is the installation, which you absolutely should use the installer for. Full installation instructions can be found here.

The second item is about creating and publishing content. Generally you do this via SSDT or the BI Components of Visual Studio (or just knock up the XML in a text editor of your choice if you feel like a challenge). Once you have created your reports you can then publish them to SSRS via Visual Studio or take the RDL file and publish it manually. There is a brief tutorial on how to do this in MS Docs.

The most important difference between these two items though is that even if you installed SSDT/Visual Studio and have created your reports, unless you have actually got somewhere to host them (i.e. by installing SSRS on a server or within Power BI Service) then you cannot share them or access them other than from within Visual Studio.

Related Solutions

Report Builder Installation – Fixing DLL Error During Report Builder CTP 2.3 Installation

Simple solution... posting for anyone else testing SQL 2016.

Do NOT supply a default SSRS Server URL during the installation process and it completes without error (Windows 2012 Datacenter and Windows 7 confirmed).

Please help MS fix this issue. Happy reporting!

SSRS 2016 – Change Connection String in All Reports

You can use the replace value of XML DML command to modify the value stored in the connection string. I have put together an example below for you as a guide but please note that it is untested as I do not have access to a report server at the moment, it should at least point you in the correct direction:

WITH XMLNAMESPACES  -- XML namespace def must be the first in with clause.
(DEFAULT 'http://schemas.microsoft.com/sqlserver/reporting/2006/03/reportdatasource'
        ,'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
 AS rd)
,SDS AS
(SELECT SDS.name AS SharedDsName
       ,SDS.[Path]
       ,CONVERT(xml, CONVERT(varbinary(max), content)) AS DEF
 FROM dbo.[Catalog] AS SDS
 WHERE SDS.Type = 5)     -- 5 = Shared Datasource
SELECT [SharedDsName], [Path], [DEF]
  INTO #catalog
  FROM SDS;

UPDATE #catalog
   SET DEF.modify ('
    declare namespace rds="http://schemas.microsoft.com/sqlserver/reporting/2006/03/reportdatasource";
    declare namespace rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner";
    replace value of (/rds:DataSourceDefinition/rds:ConnectString/text())[1]
    with "new connection string"
');

UPDATE a
   SET a.[Content] = CONVERT(image, CONVERT(varbinary(max), b.[DEF]))
  FROM dbo.Catalog AS a
  JOIN #catalog AS b
    ON a.[Name] = b.[SharedDsName]
   AND a.[Path] = b.[Path];

DROP TABLE #catalog;

More information regarding the replace value of command can be found at Microsoft Docs.

Best Answer

Related Solutions

Report Builder Installation – Fixing DLL Error During Report Builder CTP 2.3 Installation

SSRS 2016 – Change Connection String in All Reports

Related Question