Solved

sharepoint 2010 powerpivot w/dedicated sql 2008 r2 server

Posted on 2012-03-27
8
496 Views
Last Modified: 2012-03-28
Am I correct in my research on this, that in order to get power pivot functioning in a brand new topology, I have to set it up as a single server instance and *then* migrate the databases to the dedicated SQL server?  This makes me sad, as it's a new environment and I just want to get my sharepoint on one server and sql on another so that I can add other instances to the sql server for other applications.

Versions:

SQL Server 2008 r2 (enterprise)
Sharepoint 2010 (enterprise)
Windows 2008 r2
0
Comment
Question by:pwnbasketz
  • 4
  • 4
8 Comments
 
LVL 38

Expert Comment

by:Justin Smith
ID: 37776402
No, if I'm reading this correctly, you don't have to.  Right now you have one SharePoint Server, and one SQL Server, right?  If so, you can either install PowerPivot on your existing SharePoint server, or  you can set up another SharePoint server, and install PowerPivot on it.
0
 
LVL 4

Author Comment

by:pwnbasketz
ID: 37777657
Right now I have Server1 with SQL on it, and am setting up a new farm for Sharepoint (with Power Pivot) on Server2, so I am wanting to set it up so that Server2 only has Sharepoint on it and is hosting it's databases on Server1.  I'm just having a lot of trouble (and I think it's just because of the necessary setup requirements for power pivot) getting it initially configured in that way.  It seems like it might be intentional, with the Sharepoint is scalable as a standalone product viewpoint - where as capacity is utilized, you can then scale out to include more tiers in the hierarchy.  I could be wrong and missing something though =)
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 37777726
What trouble are you having specifically?  Take PowerPivot completely out of the situation right now......are you having trouble deploying your SharePoint farm on its own?
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 4

Author Comment

by:pwnbasketz
ID: 37777743
New SharePoint farm on Server2 and having it use SQL on Server1, if we're taking PowerPivot out of it.
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 37777778
So when you are creating your farm, and you specify your DB Server and Config DB, is it throwing an error?
0
 
LVL 4

Author Comment

by:pwnbasketz
ID: 37777821
I can't really say.  I was facing a deadline, so I configured it as a single server solution and am now migrating it into a multi-tiered implementation so I stopped pulling my hair out.  I was just surprised that due to the installation restrictions imposed by installing powerpivot and making a new farm, you couldn't specify a non-local sql server to have the information hosted on and figured i might have missed something...
0
 
LVL 38

Accepted Solution

by:
Justin Smith earned 500 total points
ID: 37777885
So right now all your db's live on Server2, correct?  If you are trying to turn a Basic single server install into a farm, it's not going to happen.  You are going to have to backup your content db's, blow the farm away and start again.  You'll restore your db's to Server1, re-run the config wizard on Server2 to create a new farm, and make Server1 the db server.  Then you install PowerPivot on Server2.

If you ever need remote assistance, I'm available.  My email address is in my profile.
0
 
LVL 4

Author Comment

by:pwnbasketz
ID: 37777906
Per above, I am starting over with that order =)
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

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.
You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…

777 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