Gets the value of a querystring with Javascript

by ebarcza 8/23/2012 12:37:00 PM
   1:  // Gets the value of a querystring key
   2:              function GetQuerystring(ji) {
   3:                  //debugger;
   4:                  hu =;
   5:                  gy = hu.split("&");
   6:                  for (i = 0; i < gy.length; i++) {
   7:                      ft = gy[i].split("=");
   8:                      if (ft[0] == ji) {
   9:                          return ft[1];
  10:                      }
  11:                  }
  12:              }



ReportServer empty homepage

by ebarcza 8/21/2012 12:06:00 PM

Log into the reporting services as administrator, you should have all the options available to you. Once logged in add the appropriate user by performing the following steps:

1.Open the Report Manager with administrator privelege.
2.In the Home page, click "Properties" tab.
3.Click "Security" tab.
4.Click "New Role Assignment".
5.Type the certain users(or the group of these users) in the "Group or user name textbox".Do this even if the target user is already in the administrators group
6.Check the "Browser" role or any/all roles that are appropriate
7.Click OK to apply.


Log in again and you should be all set


HTTP Error 404.2 - The page you are requesting cannot be served because of the ISAPI and CGI Restriction list settings on the Web server.

by ebarcza 8/21/2012 10:59:00 AM
  1. Open IIS Manager and click the server name
  2. Open "ISAPI and CGI Restrictions"
  3. Right click ASP.NET v1.1 and select "allow"



SQl Server Default Instance

by ebarcza 8/20/2012 6:00:00 AM

The default instance name for SQL Server is MSSQLSERVER



Deleting records without logging SQl Server

by ebarcza 8/6/2012 11:54:00 AM

Use truncate Table <tablename>

EX:Truncate Table tbl_Volumes_4_13_2012


BOOM! records gone and no bloated log!



The permissions granted to user domain/username insufficent SSRS Report - rsAccessDenied

by ebarcza 8/6/2012 10:16:00 AM

NOTE: Even though the user was in the admin group, I had to do this anyway...

How to Fix: 

  1. Make sure Report Manger is running by going to the URL http://localhost/reports using the SQL Reporting Services Configuration. To do this:
    1. Open Reporting Services Configuration Manager -> then connect to the report server instance  -> then click on Report Manager URL.
    2. In the Report Manager URL page, click the Advanced button -> then in the Multiple Identities for Report Manager, click Add.
    3. In the Add a Report Manager HTTP URL popup box, select Host Header and type in: localhost
    4. Click OK to save your changes.
  2. Now start/ run Internet Explorer using Run as Administator...  
    • NOTE: If you don't see the 'Site Settings' link in the top left corner while at http://localhost/reports it is probably because you aren't running IE as an Administator or you haven't assigned your computers 'domain\username' to the reporting services roles, see how to do this in the next few steps.
  3. Now browse to: http://localhost/reports  You will most likely have to login
  4. You'll be directed to the Home page of SQL Server Reporting Services here: http://localhost/Reports/Pages/Folder.aspx
  5. From the Home page, click the Properties tab, then click New Role Assignment
  6. In the Group or user name textbox, add the 'domain\username' which was in the error message (in my case, I added: ebarcza for the 'domain\username', you can find the domain\username for your computer or application in the rsAccessDenied error message).
  7. Now check all the checkboxes; Browser, Content Manager, My Reports, Publisher, Report Builder, and then click OK.
  8. You're domain\username should now be assigned to the Roles that will give you access to deploy your reports to the Report Server.  If you're using Visual Studio or SQL Server Business Intelligence Development Studio to deploy your reports to your local reports server, you should now be able to.
  9. BOOM! Works on my machine :)


SQL Server Reporting Services

Powered by BlogEngine.NET
Theme by Mads Kristensen

About the author

Name of author Author name
Something about me and what I do.

E-mail me Send mail


<<  September 2022  >>

View posts in large calendar

Recent comments



The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2022

Sign in