Home > C# on .NET > How to publish SSRS report to anonymous web site using ASP.NET (#1/3) – Prerequisites

How to publish SSRS report to anonymous web site using ASP.NET (#1/3) – Prerequisites

 

This article is to describle the way how to publish a SSRS (SQL Server Reporting Services) report with aspx to a web site on IIS. Very simple requirements, and steps will be used to help your understanding for overall steps.

The overall steps are as follows,
. Set SSRS configurations
. Create a sample DB, and table
. Create a user account to be used in ASP.NET and SSRS/SQL
. Build a report using SSRS
. Build a ASP.NET application (Web Form)
. Create a web site for the report (assumes IIS and SSRS are in a single server)

After all, let anonymous users access a report(aspx) from SSRS, using a web browser with a configurable URL such as ‘http://report.sample.server/default.aspx’ as shown below.

image

FYI, if you’re not familiar with using Windows Server, Visual Studio, and SQL, this article may fail to help you to see the result of SSRS application here. Understand me that the purpose of this post is not introducing SSRS, Visual Studio, SQL, and IIS.

 

Reporting Services Configuration


This step is required to set configurations for any reports to be accessed by asp.net using DataSet, DataSource of SSRS

Open ‘Reporing Services Configuration Manager’ on SQL server, as shown below,

image

Click ‘Start’ to move forwrd,

image

In ‘Web Service URL’ tab, configure port and check the name of ‘Report Server URL’ to be used later. In many cases, it’s just required the port number in above screen. For this case, Report Server URLs is ‘http://jchoi02:802/ReportServer’.

Note that you don’t need to configure anything in IIS server yet, but just avoid duplicated port number with other services including any web sites in IIS.

Click ‘Report Manager URL’ to configure it. To make any change, click ‘Advanced’ button

image

For this case, ‘Report Manager URL’ is ‘http://jchoi02:80/Reports’, to be used later

 

Creating sample DB and table in SQL Server


Let me prepare a very simple DB and table as shown below, you can refer the name of table, and data to be preared,

image

I created TestDB as a database, and UserAge as a simple table as simple as possible. The above data will be used in a report to be published on web site

 

Creating a user account on Windows and SQL


Using a ‘Computer Management’ on Windows Server, I created ‘ReportWebUser’, and just set a password and password option as shown below

image

This is a local account on Windows, so it assumes this account can be used in IIS, and SQL in a same server, otherwise, you may need to create AD account

Note that SQL Server should be enabled to use Windows Authentication for this case

image

After creating a Windows account (ReportWebUser), open SSMS (SQL Server Management Studio), and go to ‘Security’ > ‘Logins’  and click ‘New Login…’ as shown above.

Set a ServerName\ReportWebUser, just created, and apply db_datareader permission at least on ‘User Mapping’ tab.

image

 

Now, we’re ready to proceed to build a SSRS report, and ASP.NET application to display the report on a anonymous web site. This will be covered in a next post.

 

Related reference articles

How to publish SSRS report to anonymous web site using ASP.NET (#2/3) – Buiding SSRS reports
https://fullsocrates.wordpress.com/2016/06/30/how-to-publish-ssrs-report-to-anonymous-web-site-using-asp-net-23-buiding-ssrs-reports/

How to publish SSRS report to anonymous web site using ASP.NET (#3/3) – Buiding ASP.NET application
https://fullsocrates.wordpress.com/2016/06/30/how-to-publish-ssrs-report-to-anonymous-web-site-using-asp-net-33-buiding-asp-net-application/

Advertisements
Categories: C# on .NET

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: