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

x
?
Solved

Installing separate Report Server

Posted on 2008-10-02
9
Medium Priority
?
321 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
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 

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
 

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 1000 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Every system administrator encounters once in while in a problem where the solution seems to be a needle in haystack.  My needle was an anti-virus version causing problems with my Exchange server. I have an HP DL350 with Windows Server 2008 Stand…
Know what services you can and cannot, should and should not combine on your server.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…

916 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