Skip to main content

SQL Reporting Service - SSRS Installation & Configuration

In this blog i informed you about SSRS reporting installation & Configuration
Normally during installation of SQL server 2005 and 2008 we did not check mark Report server and also did not use instance name in sql server
Setup Instruction
Technical Issue
the first thing you need to run the SSRS is to install the custom instance name in your SQL server installation
Second you must select the Reporting service and business intellignece service in the setup
Configuration Steps & Instructions
There are many tutorials that defines you the installation & configuration and i am not rewrite every thing because i am consentrating on the problem that arrives after doing these steps please follow setps in the below mentioned URL
Major Instruction for Vista and windows 7 users
  1. You must start installation of sql sever by using main administrator user
    If administrator user is not enable you just follow these steps
    Start > Control Panel > Select Administrator >Select Small icons (in the top right category section) > Select Administrative tool >Select computer management >Select Local users and groups > Users > double click on administrator user and Add uncheck the disable account
  2. Login your Administrator account and start installation of SQL server
  3. In winodws 7 you must assign IISUser and the Network user in an administrator group this is very important to run all services in reporting server
How to assign the IIS USER and network user in administrator group in windows 7
  1. Click on start
  2. Right Click on your "Computer" tab
  3. Click on manage
  4. Expend Local Users & Groups
  5. Click on Group
  6. Click on Administrartors
  7. Click on ADD (bottom buttom) 
  8. Select User window open
  9. Click on Advance
  10. Click on FindNow
  11. Select the IUSR from the list
  12. Click ok
Repeat the 1 - 10 step again for adding the network service account
  11Select the Network service account
  12. click ok

Please follow this URL for installation and configuration
or check this
Rashid Imran Bilgrami
CEO Best Visualization


Popular posts from this blog

How to convert and crack windows server 2012 from Evaluation to Full

Dear All

This is a way how you Convert Evalution to Full


Open CMD and run following command
DISM /online /Get-CurrentEdition

<edition ID> is like ServerStandard with out Eval

Step 2:
DISM /online /Set-Edition:<edition ID> /ProductKey:XXXXX-XXXXX-XXXXX-XXXXX-XXXXX /AcceptEula

Serial Key

Windows Server 2012
DataCenter: 48HP8-DN98B-MYWDG-T2DCC-8W83P
Datacenter: Y4TGP-NPTV9-HTC2H-7MGQ3-DV4TW

Standard: XC9B7-NBPP2-83J2H-RHMBY-92BT4

Server Essentials:K2XGM-NMBT3-2R6Q8-WF2FK-P36R2

For Standard R2 here is a command
For R2 its like that
DISM /online /Set-Edition:ServerStandard /ProductKey:DBGBW-NPF86-BJVTX-K3WKJ-MTB6V /AcceptEula


Calling LoadLibraryEx on ISAPI filter “C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_filter.dll” failed

Dear Readers
if you get the error

Calling LoadLibraryEx on ISAPI filter “C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_filter.dll” failed

Here is the solution 
Get a command prompt in administrator mode and go to C:\Windows\Microsoft .NET\FrameWork64\
and run aspnet_regiis -r. This will re-register the right libraries. It has happened twice already to me.
For other frameworks (32 bit or other versions of .net make sure you go to the correct folder (i.e. Framework/, etc.)

xxxx is the the number which is present with the folder name so i suggest you guys to check the folder name in your directory

If "run aspnet_regiis -r" is not working and if you get the error run is not recognized command then just type " aspnet_regiis -r" it will run fine

Reason of problem
Your frame work has been change may be you have install the lower version on the higher version or may be because of any reason you have register another version in your IIS, in my cas…

RegisterStartupScript updated way to right Java script JS (Javascript) in code behind also work with update panel

Dear All
RegisterStartupScript is obsolete now the new way that works with update panel  is given below its is code behind file code also

VB Code Dim csname1 As String = "PopupScript"
Dim cstype As Type = Me.GetType()
Dim cs As ClientScriptManager = Page.ClientScript
Dim cstext1 As String = "alert('Your message');"
cs.RegisterStartupScript(cstype, csname1, cstext1, True)

C# Code
String csname1 = "PopupScript";
Type cstype = this.GetType();
ClientScriptManager cs = Page.ClientScript;
String cstext1 = "alert('Hello World');"; cs.RegisterStartupScript(cstype, csname1, cstext1, true);
I hope it will help you also 
Regards  Rashid Imran Bilgrami