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
 
 
 
Regards
Rashid Imran Bilgrami
CEO Best Visualization

Comments

Post a Comment

Thanks for the Comments , Your review will display soon

Popular posts from this blog

OLEDB jet 4.0 driver In Vista 64bit / he 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine

Well i think you must be thankful for me specailly for this research i am really getting the solution after 6 month research that is how to enable the oledb jet 4.0 driver in vista, i read arround 100s of articles and maximum said that is not possible to enable it and ala bla well at the end i got the answer that is so easy Acctually that is correct that oledb jet 4.0 driver is not avaialble for 64 bit but if you run your IIS on 32 bit instead of 64 then Oledb jet will working fine Here are the steps Click on the Start > Program > Administrative Tool > IIS Management panel Select the Computer name Right click on the application pool and select properties Select "TRUE" in Enable 32 Bit Application by default it is false Then this problem will resolve if you need any assitance then feel free to email me rashidbilgrami@hotmail.com Regards Rashid Imran Bilgrami CEO Best visualization www.bestvisualization.com
3 comments
Read more

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

Dear All This is a way how you Convert Evalution to Full Step1: 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 WINDOWS SERVER 2012 Serial Key Windows Server 2012 DataCenter: 48HP8-DN98B-MYWDG-T2DCC-8W83P Datacenter: Y4TGP-NPTV9-HTC2H-7MGQ3-DV4TW Standard: XC9B7-NBPP2-83J2H-RHMBY-92BT4 Standard R2: DBGBW-NPF86-BJVTX-K3WKJ-MTB6V 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 Regards
Post a Comment
Read more

SQL Agent disabled / how to enable SQL agent

Dear Readers, Today i found that SQL agent is disabled and i can active through the below process First you can check first these points Go to run type services.msc Right click on the SQL Server Agent (MSSQLSERVER) Then check in the properties your startup type might be disabled change it to automatic or manual and try again it will enable the start option If the above process not workable then check this one SQL Server blocked access to procedure 'dbo.sp_get_sqlagent_properties' of component 'Agent XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Agent XPs' by using sp_configure. For more information about enabling 'Agent XPs', see "Surface Area Configuration" in SQL Server Books Online. You need to run the following script under you SQL management Studio 1) Open the new query 2) Past the code sp_configure 'show
Post a Comment
Read more