Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 How do I install SQL Reporting Service?

Author  Topic 

walterbyrd
Starting Member

12 Posts

Posted - 2011-06-08 : 16:41:03
My Setup:
- HP G62 laptop with i3 processor and 4GB of RAM
- Windows 7 64-bit
- MS-SQL Server 2008 R2 (Express Editon)
- Laptop name: Oak
- Database Server Name: SQLEXPRESS


I am new at this.

From what I have read, the Reporting Service should have been installed when I installed SQL-Server. But, I guess I did not install it - I guess.

"Reporting Services Configuration Manager" is available from my programs menu. But when I try to run it, it will not Find, or accept, any Server Name.

When I connect to Management Studio, the server name is displayed as "OAK\SQLEXPRESS." The "Reporting Services Configuration Manager" will not accept that name, or any variation of that name. I get the error: "Report Server WMI Provider Error: Invalid namespace."

Also, I am not sure what is meant by "Report Server Instance."

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2011-06-09 : 01:19:21
do you see anything like sql server business intelligence under all programs....
Go to Top of Page

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2011-06-09 : 07:04:56
I have not done this, but I would think that you need to use the installation CD and use the "add features" option. A quick googling seems to indicate the same, for example:

http://www.gotknowhow.com/articles/how-to-install-sql-server-2008-reporting-services-ssrs

http://www.mssqltips.com/tip.asp?tip=1444
Go to Top of Page

walterbyrd
Starting Member

12 Posts

Posted - 2011-06-09 : 11:14:08
I do not have an installation CD. I just downloaded SQL-Server Express. Maybe I could just re-run the installation application.
Go to Top of Page

walterbyrd
Starting Member

12 Posts

Posted - 2011-06-09 : 14:28:38
Maybe this just cannot be done with the express version? I re-ran the installation application. I chose "New installation or add featrues to an existing installation." But I do not see anything like what I want. It looks like everything I can chose has already been chosen anyway, i.e.: "SQL Server Replication", "Management Tools - Basic", "SQL Client Connectivity SDK."
Go to Top of Page
   

- Advertisement -