Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

sharepoint 2010 powerpivot w/dedicated sql 2008 r2 server

Posted on 2012-03-27
8
Medium Priority
?
503 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

These days socially coordinated efforts have turned into a critical requirement for enterprises.
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
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 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…

604 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