Solved

sharepoint 2010 powerpivot w/dedicated sql 2008 r2 server

Posted on 2012-03-27
8
493 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
 
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
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

Do email signature updates give you a headache?

Do you feel like you are constantly making changes to email signatures? Are the images not formatting how you want them to? Want high-quality HTML signatures on all devices, including on mobiles and Macs? Then, let Exclaimer solve all your email signature problems today.

Join & Write a Comment

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…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
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…

758 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