SQL Server Reporting Services 2016 Web Portal errors

SQL Server 2016 SP1 on Windows 10 Professional on a Dell Laptop

Report Manager (Web Portal URL) has reports embedded, folders etc. Report server; Report Manager and Report Builder 3 are all working.

Trying to create a New Subscription or New History Snapshot produces error. Report user is administrator of SQL Server 2016 SP1 as well as installer. The current user is also the Reporting Services Administrator. The report is neither a linked report not does it have parameters. Data Source credentials are that the report author who is also the current user as well as the server installer on the Windows 10 Pro laptop.

Here are the messages. Some MSDN content on MSDN site related to this subject is outdated and does not relate to some of the procedures mentioned in MSDN articles.

SQL Server 2014 Report Builder 3 may have a problem

This problem surfaced while installing SQL Server 2104 Report Builder on a Windows 10 (x64) Pro machine which has a SQL Server 2014 (x64) Developer Edition installed and a properly configured Report Server.

The Report Builder software was downloaded from this Microsoft Site:
https://www.microsoft.com/en-us/download/details.aspx?id=42301

ReportBuilder_01

Double clicking the downloaded MSI file above started the installation. The program looks for a target report server and it was provided as shown:

ReportBuilder_02

The Report Server and the Report Manager both do not have any problem. However this ends up with an unsuccesful installation with this message:

ReportBuilder_03

The work around for this is to not provide a target report server and ccontinue with the installation. The installation succeeds this time. After a little while an gets added to the All Icons group as shown.

ReportBuilder_04

Hands-on training event in Honolulu: SQL Server Reporting Services 2012

This hands-on course will provide you with the ability to create cutting edge reports using Microsoft's latest reporting services product, SQL Server 2012.

The course is offered by the Pacific Center for Advanced Technology Training(PACTT): http://pcatt.hawaii.edu/home

Report writing is one of the most important IT related jobs in an enterprise. This course is for you if you would like to master report writing/authoring using SQL Server Reporting Services. The course begins with a presentation of essential technical background, after which you will work through guided hands-on exercises.
At the end of the course you will have gained:

• A solid understanding of how to interact with SQL Servers
• Knowledge and experience installing and configuring reporting Services
• A working knowledge of using Report Builder to author reports and deploy them to report server
• A working knowledge of Report Manager's ability to carry out administrative tasks related to all aspects of reports; creating shared data sources, folder and folder hierarchies on the report server, and report models; managing security and subscriptions; and configuring data driven subscriptions
• An understanding of how to embed report viewer controls in windows and web projects.

Venue: Honolulu Community College Honolulu Community College
874 Dillingham Blvd Honolulu, HI 96817-4598
Phone: (808) 845-9211
Official Website: honolulu.hawaii.edu/

Section 1 - Mar 22 - Apr  28, 2016; TTh; 5:30 pm - 8:30 pm; 12 mtgs

I will be using my latest book on SQL Server Reporting Services for this course:

More here:http://hodentekmsss.blogspot.com/2014/11/things-you-learrn-hands-on-in-my-book.html

Hands-on Learning Event in Honolulu 2: SQL Server Reporting Services 2012, November 5

The class is forming and is expected to start on November 5, 2015. Please register at the PCATT.ORG site.

Adata/Pcatt1.png

SQL Server 2012 Express or Developer Edition / Evaluation edition will be used. The emphasis is on Native Mode operation of the Reporting Services.

For details you can also write to:
Hodentek@live.com with course name in the Subject line.

Here are Reporting Services books published by the instructor:

You can buy these and many other computer and programming related books here:

https://www.packtpub.com/books/info/authors/jayaram-krishnaswamy

Hands-on Learning Event in Honolulu 2: SQL Server Reporting Services 2012

The class is forming and is expected to start in August 2015. Please register at the PCATT.ORG site.

SQL Server 2012 Express or Developer Edition will be used. The emphasis is on Native Mode operation of the Reporting Services.

For details you can also write to:
Hodentek@live.com with course name in the Subject line.

Here are Reporting Services books published by the instructor:

 

 

You can buy these and many other computer and programming related books here:

https://www.packtpub.com/books/info/authors/jayaram-krishnaswamy

Training Course in Honolulu: SQL Server Reporting Services 2012

This hands-on course will provide you with the ability to create cutting edge reports using Microsoft's latest reporting services product, SQL Server 2012.

The course is offered by the Pacific center for Advanced technology Training: http://pcatt.hawaii.edu/home

Report writing is one of the most important IT related jobs in an enterprise. This course if for you if you would like to master report writing/authoring using SQL Server Reporting Services. The course begins with a presentation of essential technical background, after which you will work through guided hands-on exercises. At the end of the course you will have gained:
• A solid understanding of how to interact with SQL Servers
• Knowledge and experience installing and configuring reporting Services
• A working knowledge of using Report Builder to author reports and deploy them to report server
• A working knowledge of Report Manager's ability to carry out administrative tasks related to all aspects of reports; creating shared data sources, folder and folder hierarchies on the report server, and report models; managing security and subscriptions; and configuring data driven subscriptions
• An understanding of how to embed report viewer controls in windows and web projects.

Course code: 134F1TSQL003A

Venue: Honolulu Community College Honolulu Community College
874 Dillingham Blvd Honolulu, HI 96817-4598 Phone: (808) 845-9211
Official Website: honolulu.hawaii.edu/

Section 1 - Nov 6 - Dec 16; MW; 5:30 pm - 8:30 pm; 12 mtgs.

I will be using my latest book on SQL Server Reporting Services for this course:

 

Learn SQL Server 2012 Reporting Services is released

Learning SQL Server 2012 Reporting Services was released today by Packt publishers. This is my second book on Microsoft SQL Server Reporting Services (which may be called a second edition). It is enlarged to include Reporting Services Integration with SharePoint 2010. With 566 pages it is somewhat thicker than the first edition (Learning SQL Server 2008 Reporting Services). However, the book has a large number of screen shots like my first book and is somewhat thinner than most other books in this genre. The reviewers and technical editors have put in a lot of effort and time to make this happen.

I take this opportunity to thank the reviewers (Satya Shyam Jayanty and Ritesh Shah) for their meticulous reading of the manuscript; the technical editors, Azharuddin Sheik, Mausam Kothari, Varun Pius Rodrigues, and Lubna Shaikh and many others at Pakct Publishing for their excellent editing and Microsoft Forums' (MSDN, TechNet and SharePoint) help for answering so many of my questions.

Summary of Hands-on tasks you learn:

• Install SQL Server 2012, SharePoint Server 2010, and configure Reporting Services both native and SharePoint Integrated on Windows 7
• Install SSDT and author reports, both local and remote, and deploy them to report servers
• Develop desktop and web applications by using Report Viewer controls
• Author different kinds of reports with the latest gadgets by working with Report Builder
• Manage access to the report server, report scheduling, report delivery, report uploads, and downloads with Report Manager
• Create Tabular Models with SQL Server Analysis Services and deploy them to SSAS Server using SSDT
• Author Power View Reports from your SharePoint Site and export them as Power Point files
• Learn to create Data Driven alerts in SharePoint and monitor them on SQL Agent on SSMS
• Work with Windows Azure Reporting Services using Windows Azure Portal and SSMS
• Write applications in SSIS and WPF to access reports and access native server reports from SharePoint Site

I hope this book is appreciated as much as the earlier one.

Report Manager on the Current Browsers

The latest version of Reporting Services that gets installed when you
install SQL Server 2008 Enterprise Edition (not the RTM) has a slightly different
looking interface. This interface's look is slightly different in different
browsers.

As you can see they are different and surely Google Chrome has the wierdest look.

Firefox 3.0 and Safari

 

Google Chrome

 

IE 8.0 RC1

I Can't find these in documentation

I tried to enable My Reports in Site Settings as suggested by Microsoft Documentation for SQL Server 2008 Documentation,

http://msdn.microsoft.com/en-us/library/ms155826.aspx

but I cannot find any control (Radio button, check box) in Report Manager's Settings page to enable My Reports.




In Report Manager | Site Settings | General there is this item,

Custom Report Builder launch URL:

I also cannot find documentation about this item,

I appreciate if any reader of this blog has some idea about these.

On turning on, turning off Reporting Services Functionality

Please refer to this entry,
http://hodentekhelp.blogspot.com/2008/08/how-do-you-turn-on-and-turn-off-report.html