Solved

Dose'nt Install Reporting services SQL server

Posted on 2009-06-27
8
212 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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 is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
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.
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.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

770 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