Solved

Installing separate Report Server

Posted on 2008-10-02
9
277 Views
Last Modified: 2013-11-21
Test environment - central site installed, separate server for SQL 2005, and several secondary sites (boundaries set up, client install tests successful).  I would now like to install a separate Reporting site server.  Since the Reporting server must be a primary site, I am running into issues during the SQL section of the site install screens. Can this new primary site utilize the current database from the central site?  During install it states that 'this database is not empty - do you want to empty/overwrite it).  How exactly is 'child' primary site set up so I can use it as a reporting site with the current active database on the SQL server?  I have tested my central site as a reporting site, and that went smoothly, but I have the extra hardware to set up a separate site for reporting and would like to follow that route.
Thanks.
0
Comment
Question by:techieNmore
  • 5
  • 4
9 Comments
 
LVL 8

Expert Comment

by:U_Mansson
ID: 22624493
Hi

I'm not sure if I understand your question correctly. You currently have a site server with the Report Site role installed on it. Now you want to separate that role from the site server and run it on a different hardware.  Is that correct

There is no need for you to install a new site to install the site role on a different machine. Just add the server to you site and install the site role on it. You add a new site server under Site Settings - Site Systems. You need to have IIS installed on your Reporting Point by the way.
0
 

Author Comment

by:techieNmore
ID: 22628175
Thanks for the response.  The problem I'm having is different than what you are answering.  I have the extra hardware and want to build a child primary site and turn that into a dedicated reporting site (and remove the reporting role from the central site).  The problem I'm having is how to build a child primary to use/join the central site database.  Secondary sites automatically look for the central datase - building a primary wants to also create its own database, and that's where I'm stuck.  Thx.
0
 
LVL 8

Expert Comment

by:U_Mansson
ID: 22631386
Ok, I'm not really sure why you want to have a separate site for reporting anyway. :-)

The thing with a child primary site is that is has its own database, so you have to install a new database for that site. If you want to be able to make reports on the parent primary site you have to reverse the other on them. You have to make your new primary site a parent primary site to the existing primary site. You are only able to make reports on data from you own site and child sites.
Secondary sites always use the database from its parent.

By the information you have given my I still recommend that you install a Reporting Site Server in your current primary site and don't install a separate site just for reporting on the child sites. But maybe you have a good reason for this?!
0
 

Author Comment

by:techieNmore
ID: 22638824
Because of mandates, I cannot activate/use IIS on the central primary site.  For this reason, I need to set up a separate reporting site.  Here is our heirachy:
AD - extended schema - one domain
1 Central/primary site
60 secondary sites, acting as Proxy MPs and distribtuion sites (in different states across country), IIS w/bits enabled for packages
5000 total users
Since a reporting site has to be a primary site, I need to install another server.  Any suggestions as to how to make this work in my set up would be greatly appreciated.  Creating a separate reporting server is also a MS recommendation.
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 

Author Comment

by:techieNmore
ID: 22638931
I forgot to mention in the above hierachy that I have a separate server running SQL 2005 for SMS central site database.
0
 
LVL 8

Expert Comment

by:U_Mansson
ID: 22644175
Ok, I recommend that you install a new primary site and add the Reporting Role to that site server. Attach the primary site you have today as a child site to the new primary site you just created. This way you will be able to create reports on all the child site's you have.

If you attach the new primary site as a child site to the current primary site you will only be able to create reports on the new primary site and thats not what you want is it?! :-)

0
 

Author Comment

by:techieNmore
ID: 22645945
Thanks for the idea - that is sort of where I started to go on Friday.  I created another primary site on the Reporting server (with it's own new database), but then got confused as to how to make the current primary/central site a child of that newly created site.  Sorry if I'm showing my 'newness' to SMS.  The learning curve is pretty high.  If you could point me in the right direction for making the current primary a child tot he newly created primary, I'd greatly appreciate it!!
0
 
LVL 8

Accepted Solution

by:
U_Mansson earned 250 total points
ID: 22646011
Ok, no problem at all. It's a little bit late in the night here but I think I will get it right for you.

First of all configure site senders on both sites.
In SCCM console go to Site Database - Site Management - Name of your Site - Site settings then right click on Adresses. Choose New - Standard Sender Address.
Complete the wizard.
If you choose the use the computer account for the connection add the site server computer account to the local group SMS_Site toSiteConnection_[your site code]. Add the computer account on the site you want to connect to.
Do this on both your sites.

Next, on the site you want to be the child site
Start  the config mgr console and go to Site Database - Site Management - Name of your Site. Right click you site name and select properties
On the General page, click on Set Parent Site. Write the name of your new central site (or click the dropdown) and click ok.

That should be it. Normally it will take around 10 minutes before the connection to show in the console. Be sure to refresh the console if you sit and wait for it to happen.
0
 

Author Closing Comment

by:techieNmore
ID: 31502371
Thanks so much.  So it's basically exactly what I when I created and added the secondary sites (with the addresses and senders), only I'm going to do it on primary site.  I'll be all over this first thing tomorrow.  I'd remote into the test network now, but as you said, it's LATE to start something like that, especially remotely.  Thanks again.
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

On a regular basis I get questions about slow RDP performance, RDP connection problems, strange errors and even BSOD, remote computers freezing or restarting after initiation of a remote session. In a lot of this cases the quick solutions made b…
Welcome to my series of short tips on migrations. Whilst based on Microsoft migrations the same principles can be applied to any type of migration. My first tip is around source server preparation. No migration is an easy migration, there is a…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

759 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now