Here at Mavention we already do a lot of SharePoint 2013 installations at customers. I hope to produce a series of lessons learned posts about these installations. This one is about SQL and the search topology.
When you start the Config Wizard it is going to connect to your SQL server. If you receive an error that the SQL version 10.50.1600 is not supported it means that SQL Server 2008 R2 without SP1 is installed. After installing SQL Server 2008 R2 Service Pack 1 the SQL version number is 10.50.2531. This is the minimum required SQL installation for SharePoint 2013. By the way, SQL Server 2012 has version number 11.0.2100.60.
Be sure that Microsoft .NET Framework 4.5 is installed at the SQL server.
The setting “Max Degree of Parallelism” has to be set to 1 in SQL Server 2008 R2 SP1. To configure this you have to:
- login to SQL Management Studio;
- Click right at “(local) SQL Server”;
- In the window “Server Properties” go to “Advanced”;
- In the right pane you see in the section “Parallelism” the setting “Max Degree of Parallelism”. Change this to 1. (see below)
After deploying the Search Service Application for the first time, the Search Application Topology might show an error like “Unable to retrieve topology component health states. This may be because the admin component is not up and running.“
I found a post at the Technet forum about this error. Paul Stork indicated that this is caused by a WSS Usage Application Proxy that is in a Stopped state. Using the powershell script in the post solved it for me. But in other farms I did not have this issue. Might be a matter of timing.