Solved

sharepoint 2010 powerpivot w/dedicated sql 2008 r2 server

Posted on 2012-03-27
8
497 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
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

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…

828 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