Solved

Dose'nt Install Reporting services SQL server

Posted on 2009-06-27
8
238 Views
Last Modified: 2012-05-07
I am a "just starting learner " here. I used functionx's website for installation instructions and installed MS SQL server 2005 Eval Copy. But When i installed it it exactly missed those parts of the installation which involves "Reporting Services"

1. Is it dependent on the IIS?
2. But IIS is intalled on the system. (All the sub components of IIS too)
3. It also says "Detecting Installed IIS" and proceeds... So it means that IIS is in good health right?

If so where is the problem?

Do i need to do a full installation again for fixing this problem ? or i can just add Reporting services to this ?

Please Help
0
Comment
Question by:misermice
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
8 Comments
 
LVL 7

Expert Comment

by:Mohed Sharfi
ID: 24729021
Hi ,
Please Try this:
http://msdn.microsoft.com/en-us/library/ms159624(SQL.90).aspx for configuring SSRS
thanks
0
 
LVL 7

Expert Comment

by:Mohed Sharfi
ID: 24729038
Hello misermice,
this article for the installation and that for Administration
http://msdn.microsoft.com/en-us/library/ms143736(SQL.90).aspx
thanks
0
 
LVL 17

Expert Comment

by:pssandhu
ID: 24729060
If you got to this window (see screen shot one "SQLInstallation.jpg") and you clicked all options then you have Reporting Service. It is matter of configuring it.
Aslo, when you installed SQL Server, during the "system configuration check" window did you see any error messages. See the second screen shot which confirms the installation of all components.
Can you give us any specific error messages you might be getting when accessing reporting services? How do you know it is not installed?
P.

SQLInstallation.jpg
Confirmation.jpg
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 7

Expert Comment

by:Mohed Sharfi
ID: 24729065
Hi ,
take these Sample Command Lines to check your service:
http://msdn.microsoft.com/en-us/library/ms152908.aspx
thanks
0
 
LVL 1

Author Comment

by:misermice
ID: 24733491
Hello Mr Psandhu

      Thanks for your reply, but when the first time i was installing it, system configuration check didnt show any errors but showed "WARNING MESSAGE" ...............PIC 1

The messages read as in .................................................PIC 2

I know that Reporting services is not installed coz when i try connect to Reporting services from Object explorer, it said server not found.. more exactly it said ................PIC 3

And Components to install window dose'nt even let me click or select  Reporting services ......Pic 4

But as the warning messages showed up was reg IIS i did look at IIS it looks completely installed....PIC 5

Please help





sysconfigurationcheck.jpg
iiswarning.jpg
rprerror.jpg
components.jpg
iis.jpg
0
 
LVL 17

Accepted Solution

by:
pssandhu earned 500 total points
ID: 24733737
So you are getting an error. That means the setup is not detecting the IIS on your machine therefore you cannot install Reporting Services as you in PIC3. This may sound a bit too obvious but have you made sure that IIS is running. If IIS is installed but not running then SQL server cannot determine if you have IIS or not.
If it is not running try starting the services and then run SQL Server setup again to see if you get the option enabled for installing Reporting Services or not.
P.
0
 
LVL 1

Author Comment

by:misermice
ID: 24748820
Hi  P

   I did verify if IIS is running, in teh services, i saw it running. But still iam not able to get the option of enabling for installaing reporting services

my verification is in the pics

servpng.png
0
 
LVL 1

Author Closing Comment

by:misermice
ID: 31597592
The solution was helpful but not accurate.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question