Skip to main content

Permission in SQL Server Reporting Services (SSRS)

Image
By

One of the frequently asked question in many forums is “I am an admin on the machine (Windows Vista or Windows 7 or Windows 2k8) where SSRS is installed but I am not able to access the reports”.

Recently I faced a similar issue. I am an admin on the machine which has Windows 2008 R2 installed. On top of it, I installed SSRS 2008 R2 and then configured the RS with proper values.

Then when I tried to access the report manager by navigating to the URL, I got an error message like:

 

User ‘Domain\User’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

 

I once again checked my configuration but everything looked fine.

Since the error message gave some hint on UAC, I ran the browser as admin and navigated to the report manager.

Now it did not throw any error message. I was able to see the home page and all other menu including the Site Settings.

I added myself as System Admin in the Site Setting:

 

Closed the browser and opened it again in normal mode. Still it was throwing same error.

Opened the browser again in Admin mode.

Navigated to the home folder and added myself and assigned to all the roles.

 

 

After this when I ran the browser in normal mode, I was able to access all report manager and all the folders.

 

The issue is that by default UAC allows the users (even the administrators) to do the tasks with the privilege of normal user, i.e., say when you open the browser or an application, it is opened with the normal user’s privilege and not that of administrator’s privilege.

 

What I understood is that when I opened the browser in normal mode, UAC passed standard user’s privilege to SSRS and hence SSRS was not able to identify that I am an admin.

To get the admin access either I have to run the browser in admin mode or add myself explicitly to SSRS System Admin roles.

 

So you have two options to tackle this issue

·         Fix it at your SSRS end as outlined above (or)

·         Manage your UAC appropriately. Have a look at the below one to know more about UAC and how to manage it.

 

http://technet.microsoft.com/en-us/library/cc709691(WS.10).aspx

 

I went for the first option as UAC is mandatory in my ORG and also it helps you to secure your machine.

 

DISCLAIMER ========== This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.

Comments

Post a Comment

Popular posts from this blog

WPF-MVVM: RelayCommand Implementation

By
In WPF if we are implementing MVVM pattern then we need to play with Command rather than Events. You can use ICommand interface to create each command class. Implementation of ICommand in a class gives you CanExecute(), Execute() methods which take part in the action performed by Command.   Rather than making Command Class for each Command we can implement a generic Relay Command to get Command. Below is a RelayCommand class that we will implement.   ///   <summary>      ///  To register commands in MMVM pattern      ///   </summary>      class   RelayCommands  :  ICommand     {          readonly   Action < object > _execute;          readonly   Predicate < object > _canExecute;  ...
Post a Comment
Read more

iOS Dev: Encryption in Objective-C

By
Hello Friends: In this Article/Post, I introduced the one encryption technique in Objective-C.  Encryption Component Features in all  Symmetric Encryption: AES, Blowfish, Twofish, RC2, ARC4, DES, 3DES, PBES1, PBES2. Hash Algorithms :  SHA-1 , SHA256, SHA384, SHA512, MD2, MD4, MD5, HAVAL. Hash Algorithms: RIPEMD128, RIPEMD160, RIPEMD256, RIPEMD320. Encoding: Base64, hex, quoted-printable,  URL-encoding . HMAC with any supported hash algorithm: HMAC-MD5,  HMAC-SHA1 , etc. Password-based Key Derivation Functions: PBKDF1, PBKDF2 PKCS7 -- P7S and P7M creation, decryption, verification. Public key encryption/decryption with digital certificates. Digital signature creation/verification with digital certificates. Bzip2 in-memory compression. Encrypt / decrypt strings or byte data. Return encrypted data as Base64, quoted-printable, or hex-encoded strings. Hash strings or binary data using SHA1, MD2, MD5, HAVAL, SHA384, or SHA512. Public-key encryp...
1 comment
Read more

iPhonegap: Developing a PhoneGap Application

By
Tutorial: Developing a PhoneGap Application Reference :  Here In this tutorial, you create a fully functional employee directory application with  PhoneGap . You will learn: How to use different local data storage strategies. How to use several PhoneGap APIs such as Geolocation, Contacts, and Camera. How to handle specific mobile problems such as touch events, scrolling, styling, page transitions, etc. How to build an application using a single page architecture and HTML templates. How to build (compile and package) an application for 6 platforms using  PhoneGap Build . To complete this tutorial, all you need is a code editor, a modern browser, and a connection to the Internet. A working knowledge of HTML and JavaScript is assumed, but you don’t need to be a JavaScript guru. Setting Up Download the assets for the workshop  here . Unzip the file anywhere on your file system. If your code editor allows you to “open a directory”, open the phonegap...
Post a Comment
Read more