Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Dose'nt Install Reporting services SQL server

Posted on 2009-06-27
8
Medium Priority
?
248 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
  • 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
Technology Partners: 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 1500 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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

886 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