sharepoint 2010 powerpivot w/dedicated sql 2008 r2 server
Posted on 2012-03-27
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.
SQL Server 2008 r2 (enterprise)
Sharepoint 2010 (enterprise)
Windows 2008 r2