Solved

Dose'nt Install Reporting services SQL server

Posted on 2009-06-27
8
226 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

726 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