?
Solved

sharepoint 2010 powerpivot w/dedicated sql 2008 r2 server

Posted on 2012-03-27
8
Medium Priority
?
500 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

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