Report Manager–“Run as Administrator”

The magic of “Run as Administrator” shines many places with no exception in report manager(RM, which is a Reporting Service web portal). If you run IE/Chrome to open the RM, you only can see this,

RM1

On the other hand, if you run your IE/Chrome or other explorers in “Admin” mode(Right click–>Run as administrator), it looks like below. There are two outstanding features only available for “admin” mode–“site settings” and  “User Folders”.

RM

You can setup Reporting Service instance level properties in “Site Setting” feature and , when “My Reports” feature has been enabled, “Users Folders” option gives administrator to explorer all users’ preference pre-stored reports or linked reports.

Keep in mind magics only show up in “Run as Administrator” mode but not in the normal mode though you truly are an administrator.

My Friends, give a shoot by yourself.

Who disabled my Reporting Service Instance Property in Management Studio?

Did you ever try to use SQL Server Management Studio(SSMS) to connect your Reporting Service engine? I believe you may connect SQL Server Database Engine or SSAS much more often but fewer people try this way to SSRS.

This thread is to walk through this option using SSMS to connect your reporting service.

To start, launch your SSMS in your start menu. In the SSMS connect dialog, choose “Reporting Services” in your service type and fill in the RS server name, also let’s choose windows authentication for this case then hit “connect” button. Yes, it takes a little bit longer time to connect if this is your first time to do so. Now connected!

First question you may have is what we can manage for SSRS in SSMS. In SSMS, we can manage all instance-level options including jobs, Security roles, shared schedules and the most important one, as least to me, is the property setup for SSRS. Now, let’s right click SSRS instance, in the following popup menu, please check out your last item: property. Surprise? Yes, it surprised me for a couple of times when I started to use this tool in the earlier time. The “property” item is, by default, disabled as shown in below picture.

SSMS-SSRS1How to turn it on? Easy and tricky! Shut down your SSMS first. Go to the Start menu and find the shortcut of SSMS, right click on it, choose “Run as administrator” in the popup menu. And connect to SSRS again. What do you see? It is working this time, right?!

SSMS-SSRS2

Now, you ask, if the login I am using to connect SSRS is the member of Administrator Group, do I still need to run as administrator? The answer is firmly YES! Further, let’s check what we can setup in property window. A lot: Portal name, Enabling “My Reports”, execution options, History, logging and security, I like it, you know what. For some options, this is the only approach you can setup SSRS instance-level properties.

SSMS-SSRS2

Alright, guess you got it. Have fun with SSRS property setup. See you next time.

12/26/2014

Reporting Service Error: The service did not respond to the start or control request in a timely fashion.

 

Did you meet this issue before? When you try to launch the reporting service, it complains “The service did not respond in a timely fashion”. Usually I think RS is just a piece of cake but this time it seems to be a hard bone.

The reason this time is different is you have no places to check errors with the only exception of event viewer. In your RS log, no info has been dumped out yet because your RS has not started to work. In your event viewer, it only reminds this tedious statement “The service did not respond to the start or control request in a timely fashion.” whatever how many times you attempt to start your RS.

I searched around for solutions this morning. Seems below situation fits for most.

It is because of security upgrading.

so the solution is to either to uninstall the KB(s) or increase the timeout of responding time of the service.

Please refer as below

I uninstalled that first patch (KB948109) and the service came back up. (I thought the sysadmins had rolled back that patch already, but apparently they had only removed KB951248).

or to increase the timeout  as this linker

http://support.microsoft.com/kb/839803

However, this fix doesnt fit for me after trying. My one is because of trust betweem domains.

As a last resort before lunch, I tried to launch RS with windows login instead of the service account. Hum~~guess what…? It worked!

Why? My windows account and RS server are in the same domain but the original service account is in the other domain. Thus, when you start the RS, it goes to check your service account validness by communicating with the other domain. Somehow, the other domain cannot respond as quick as it is expected. Then, RS pops up “not in a timely fashion”. Make sense?!

My 2 cents. Maybe some value for you. Hopefully!

Take care.

 

09/23/2013

Dallas, TX

 

 

 

 

 

How to repeat the column header for tablix in SSRS2008 R2

Issue: “When creating a tablix control with Repeat Column Header set to true the Column Headers are not repeated”.

In the tablix control, when click row header handle then right click it to set the “Repeat header column in each page” in the “tablix property”, as we all ses the option name is quite self-explanation but unfortunately it does not work in most cases.

Below the steps are listed to solve this.

1) Select the Tablix that you want to repeat column headers for by clicking on it.

2) At the bottom of the screen, find the “Row Groups” and “Column Groups” section.
3) Click the small drop-down-arrow on the right side of that section.
4) In the “Row Groups” section, locate the top-outermost “static” row and click on it.
5) In the properties pane, you need to set the following TWO properties:
a) RepeatOnNewPage = True
b) KeepWithGroup = After