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
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Reporting Services 2008R2

Author  Topic 

kesve
Starting Member

4 Posts

Posted - 2011-10-10 : 02:42:41
Hi!

How do I install Reporting Services in SQL2008R2 in operation server?
Best regards

Kenneth

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-10 : 02:44:07
you're planning to use same server as db as well as reporting server?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

kesve
Starting Member

4 Posts

Posted - 2011-10-10 : 02:52:12

Yes same server and db

quote:
Originally posted by visakh16

you're planning to use same server as db as well as reporting server?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/



Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-10 : 02:54:36
ok. hope your reporting needs are not much resource intensive. Had you installed full installation of r2? go to services.msc and check if you're reporting services service available. also check if its running

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

kesve
Starting Member

4 Posts

Posted - 2011-10-10 : 04:32:25
Reporting services is not available in services.msc, how do I to install in MSSQL2008 R2




quote:
Originally posted by visakh16

ok. hope your reporting needs are not much resource intensive. Had you installed full installation of r2? go to services.msc and check if you're reporting services service available. also check if its running

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/



Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-10 : 04:39:00
quote:
Originally posted by kesve

Reporting services is not available in services.msc, how do I to install in MSSQL2008 R2




quote:
Originally posted by visakh16

ok. hope your reporting needs are not much resource intensive. Had you installed full installation of r2? go to services.msc and check if you're reporting services service available. also check if its running

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/






You need to again run the installation cd/file and choose reporting services component

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

kesve
Starting Member

4 Posts

Posted - 2011-10-10 : 05:46:32

When I select reporting service, Instance Configuration choose Default instance. Errors " The instance name is already in use"
What to do?

quote:
Originally posted by visakh16

quote:
Originally posted by kesve

Reporting services is not available in services.msc, how do I to install in MSSQL2008 R2




quote:
Originally posted by visakh16

ok. hope your reporting needs are not much resource intensive. Had you installed full installation of r2? go to services.msc and check if you're reporting services service available. also check if its running

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/






You need to again run the installation cd/file and choose reporting services component

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/



Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2011-10-10 : 06:53:44
Do not install the sql server engine again, just reporting services. Then you will not have this problem.

- Lumbago
My blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/
Go to Top of Page
   

- Advertisement -