Archive

Archive for July, 2011

What is the difference between Uri and UriBuilder?

July 12, 2011 5 comments

The answer for this question would be similar to the question below:

What is the difference between String and StringBuilder?

Why? because they are similar in concept. A Uri/String is immutable (read-only, if you will). A UriBuilder/StringBuilder provides a mechanish to modify the contents of a Uri/String without having to destroy and recreate a Uri/String each time (which, if done often enough, could hurt performance).

String scheme = "http";
String target = "balaji.com";
int port = 8080;
String path = sample/page1.aspx";
String query = "?query=search text";
UriBuilder u = new UriBuilder(scheme, target, port, path, query);
Categories: C# Tags: , , , , ,

rsAccessedDenied – SQL Server 2008 R2 – Reporting Services

July 7, 2011 2 comments

Recently I installed SQL Server 2008 R2 in my Laptop and I was in a process of configuring SSRS using “Reporting Services Configuration Manager”. Therefore I went to the following URLs:

Report Server: http://localhost/ReportServer
Report Manager: http://localhost/Reports/Pages/Folder.aspx

The page took more time to load, however gave me the following error even thou I was sure that I gave windows authentication for security during installation.

Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings
The permissions granted to user ‘mydomain\myAccount’ are insufficient for performing this operation. (rsAccessDenied) (ReportingServicesLibrary)

After a long research, I finally discovered that you have to open Internet Explorer in administrator mode (Right-Click and Open as Administrator) and try navigating to the above URLs. This is because initially the SSRS will have the following group “BUILTIN\Administrators” as “System Administrator” and you have to explicitly open as administrator when using Internet Explorer.

You will discover that this time you are able to load the pages and the first thing for me to do was to click on the “Site Settings” and under the Security option added my username as “System Administrator” under “New Role Assignment”.

After this done, you will notice that you can open up the Report Server / Manager URL’s under normal mode (without opening it as Administrator)

More Info from MSDN: http://msdn.microsoft.com/en-us/library/aa337279.aspx

Hope this is of help to somebody who is caught up with this issue.

%d bloggers like this: