Tracking Report Servers with rskeymgmt tool

You could use the command rskeymgmt

Here are the things you can find out about Report Servers from command lineusing HELP:

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

C:\Users\TEMP.HODENTEK9.000>rskeymgmt -?
Microsoft (R) Reporting Services Key Manager
Version 13.0.1601.5 x86

Performs key management operations on a local report server.

  -e  extract           Extracts a key from a report server instance
  -a  apply             Applies a key to a report server instance
  -s  reencrypt         Generates a new key and reencrypts all encrypted
                        content
  -d  delete content    Deletes all encrypted content from a report server
                        database
  -l  list              Lists the report servers announced in the report server
                        database
  -r  installation ID   Remove the key for the specified installation ID
  -j  join              Join a remote instance of report server to the
                        scale-out deployment of the local instance
  -i  instance          Server instance to which operation is applied;
                        default is MSSQLSERVER
  -f  file              Full path and file name to read/write key.
  -p  password          Password used to encrypt or decrypt key.
  -m  machine name      Name of the remote machine to join to the
                        scale-out deployment
  -n  instance name     Name of the remote machine instance to join to the
                        scale-out deployment
  -u  user name         User name of an administrator on the machine to join to
                        the scale-out deployment.  If not supplied, the current
                        user is used.
  -v  password          Password of an administrator on the machine to join to
                        the scale-out deployment
  -t  trace             Include trace information in error message

To create a back-up copy of the report server encryption key:
RSKeyMgmt -e [-i ] -f -p

To restore a back-up copy of the report server encryption key:
RSKeyMgmt -a [-i ] -f -p

To reencrypt secure information using a new key:
RSKeyMgmt -s [-i ]

To reset the report server encryption key and delete all encrypted content:
RSKeyMgmt -d [-i ]

To list the announced report servers in the report server database:
RSKeyMgmt -l [-i ]

To remove a specific installation from a scale-out deployment:
RSKeyMgmt -r [-i ]

To join a remote machine to the same scale-out deployment as the local machine:
RSKeyMgmt -j [-i ] -m
          [-n ] [-u -v ]

C:\Users\TEMP.HODENTEK9.000>

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

I have three report servers but two of them have a problem.

If you want to use rskeymgmt you should start the CMD program with elevated privileges as shown:

Once CMD screen is displayed you can find the report servers as shown. I am using the l and i flags in rskeymgmt. The SQL Server Report Server 2012 PCATT has no problem, while the 2016 and 2017 SQL Server instances OHANA and SSRS are showing the same exception.

C:\>rskeymgmt -l -i PCATT   ---SQL Server 2012
HODENTEK9\PCATT - 879ea471-47cf-4386-b7f1-6eb213a5fff6
The command completed successfully

C:\>rskeymgmt -l -i OHANA     ---SQL Server 2016
The profile for the user is a temporary profile. (Exception from HRESULT: 0x80090024)

C:\>rskeymgmt -l -i SSRS      --default instance of SQL Server 2017
The profile for the user is a temporary profile. (Exception from HRESULT: 0x80090024)

The previous result was obtained using a Preview Build of OS that was not working well.

Recently 9/14/2018 there was an update to the OS and things have improved. Here are some new results for the same. 

Two of them are not displaying results, in one case the Database Engine is not running and in the other the Report Server is not running.

New Subscription or New History Snapshot produces error

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.

---

Jayaram Krishnaswamy

Branding a Reporting Services Web Portal

Branding is an important feature of a Reporting Service Web Portal to drive business. It should be very attractivewith a nice logo; colors and features that should be able to choose how you present it.
This will be true for mobile reports as well. Microsoft has provided ample guidance as to how you go about branding your reporting site.

Brand Package consists of

a zip file with 3 named files:

color.json, metadata.xml,

and logo.png

Uploading a Moble report to a Report Server

This post is about displaying a Mobile Report created by the SQL Server Mobile Report Publisher after publishing the report to a SQL Server Reporting Services which is actually the Web Portal URL of the Reporting Services.

The present Reporting Services configuration is pertinent to SQL Server 2016 Reporting Services on the local machine.

While it should also be possible to publish it directly from the SQL Server Mobile Report Publisher, it was not possible because there were errors connecting to the Report Server although the SQL Server 2016 Database Engine; the Reporting Services were all up and running and an empty folder 'Reports' was created on the Web URL. I have not tried to verify the problem yet. This could be because of the constant upgrades coming to the OS automatically.

In this post, I consider uploading a report to the Web Portal URL after saving the file created by the SQL Server Mobile Report Publisher to a local folder.

You need to make sure the Reporting Services database is accessible which the same as the SQL Server Database Engine  running; the Reporting Services has started and the Service and Web Portal URL have no problems.

Then use the Upload button on your Web Portal URL to upload the report created and saved (to local file system) to the computer. Once it gets uploaded the report gets into the WEB Portal URL as shown.

The Northwind Report has three charts, the creation of one of them is detailed in my earlier post here. I have just added two more grid items this upload.

You can view each of them on the WEB Portal URL as well as shown here.

http://hodentek8/Reports_OHANA/mobilereport/Northwind

Herein http://hodentek8/Reports_OHANA is my Web Portal URL.

Download Report Builder for SQL Server 2016

Report Builder is a highly productive, stand-alone tool for authoring reports and deploying them on configured Microsoft Reporting services report servers. It can use data from different kinds of data sources to produce  a variety of reports, from hard copies to web based reporting.

Report Builder 3 Details:
--------------
Version:
14.0.344.82
File Name:
ReportBuilder3.msi
Date Published:
3/9/2017
File Size:
22.6 MB
-----------------

You need Microsoft .NET Framework 4.5. The memory and CPU requirements are average.

This is supported on  the following OSs:
Windows 10 , Windows 7, Windows 8, Windows 8.1, Windows Server 2008 R2, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Server 2012 R2

download from here:
https://www.microsoft.com/en-us/download/confirmation.aspx?id=53613

Please review the earlier versions of Report builder in two of my published books here:


The second book Learning SQL Server 2008 Reporting Services is ideal for beginners who want to spin-out reports from a variety of data sources and deploy them to report servers. The book is replete with step-by-step, hands-on exercises where the users can hone their skills.

 

 

The fifth book Learning SQL Server Reporting Services 2012 is a revised edition and a deals with both Native and SharePoint Integrated modes of Report Servers. This covers every aspect of the first edition(second book) with lots of added material to include development in the intervening years.

  As the author of these Microsoft Business Intelligence related books I have great confidence in their usefulness. I would love to hear from you. Email me at: hodentek@live.com.

In SQL Server 2014 you can use Multidimensional model to create Power View

This feature is new in SQL Server 2014.

In SQL Server 2012 Reporting Services you had the option to create Power Views using the Reporting Services Service in SharePoint 2010. In order to create the Power Views you needed to create tabular data model in SQL Server Analysis Services 2012. You needed a separate instance of SQL Server Analysis Services installed to support Tabular Data Model as the default was Multi-dimensional.

With SQL Server 2014 Power Views can be created using Multidimensional models, the same model used in OLAP Cubes. Just as Tabular Data Models supported Data Analysis Expressions(DAX), multi-dimensional models also support querying with DAX.

Power View is not exclusive to SharePoint but can be created using Excel 2013 although somewhat limited in features compared to those created using SharePoint.

Chapter 6: Power View and Reporting Services

This chapter in my book describes how to create Power Views from scratch.

Honolulu Technical Training: SQL and SQL Server Reporting Services 2012

The two non-credit courses on SQL and Reporting Services offered by the Pacific Center for Advanced Training are going to start soon. Register and upgrade your database skills.

Course content and more details here:

http://hodentek.blogspot.com/2013/12/sql-training-in-honolulu-introduction.html

Connecting to SQL Server 2012 Express from Power Pivot - 1

Previously we have seen connecting to a database from Power Query. Microsoft also has Power Pivot which also can access SQL Server 2012 to model a data source. In what way is Power Query different from Power Pivot?

There is a functionality difference between the two. Power Query is more like SQL Server Integration Services while Power Pivot is akin to SQL Server Analysis Services. Even a cursory look at the
'ribbon' would reveal this as shown:

In Power Query UI you do not see analysis related controls.

As to connecting to data you do see there is some overlap. However, Power Query can access lot more types of data sources than Power Pivot.  These are data sources that Power Query can access,

The following image shows data sources that Power Pivot can bring in,

 

 Also, review the user interface differences between the two tools, one provides more analytical support than the other,

However both Power Query as well as Power Pivot can connect to SQL Server 2012 Express by clicking on the From Database drop-down.

Go to Part 2 here:

http://hodentekmsss.blogspot.com/2014/01/connecting-to-sql-server-express-2012.html

Twiiter IPO and SQL Server

Use SQL Server Reporting Services to report from Twitter:

http://hodentek.blogspot.com/2009/06/authoring-report-using-twitter-api.html

Tomorrow is Twitter IPO. Expectations are running high. In October it was between 17 to $20. Two days ago it was 23 to $25 and today it has gone up, may be $27 to $29. Only tomorrow can tell.

On the eve of this I provide my Twitter related posts on my Hodentek blog. I seem to remember that my Twitter article to SSQUG.org was published. I will check it out.

Please follow this link:
http://hodentek.blogspot.com/search?q=Twitter

This blog is mostly about Microsoft SQL Servers

Welcome SQL Server users

I have been writing about MS SQL Servers for several years and I will be posting exclusively about SQL Servers to this blog. I will be providing links to my SQL Server articles past and present from time to time. Of course that includes SQL Server BI as well as SQL Azure.

Here is a recent article that appeard on the SSWUG.Org site that you may be interested. This is about some observations regarding installing the latest version of SQL Server 2008 on Windows 7.

http://www.sswug.org/articles/viewarticle.aspx?id=48766