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

Handling a deployment error in Reporting Services

You created a great looking report in Visual Studio 2008 using a Report Server Project template and now you try deploying it by hitting the deploy menu item in the report's drop-down contextual menu. You get an error that it cannot be deployed. Specifically you get the following Microsoft Report Designer error:


Could not connect to the report server . Verify that the TargetServerURL is valid and that you have the correct permissions to connect to the report server.

------------------------------
ADDITIONAL INFORMATION:

Unable to connect to the remote server (System)

------------------------------

No connection could be made because the target machine actively refused it IPAddress:Port(System)

------------------------------
BUTTONS:

OK
------------------------------

The first thing to know is that the Report Server you are deploying your report to is not the web server. Used to be Web Server in Visual Studio 2005 but not in Visual Studio 2008.

Although your TargetServerURL is set correctly to the ReportServer's URL it is possible that the server has not started.

Now use the Reporting Services Configuration Manager, or otherwise, connect to the Server and start it.

You can now deploy the report (the deployment success/failure will be displayed in the output window).

Get a jump start with Microsoft SQL Server 2008 Reporting Services with the Hands-on loaded book from yours truly,

http://hodentek.blogspot.com/2009/01/it-was-very-good-year.html