Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Prerequisites
Install Server 2012 R2 Operating System.
Join Server to the domain.
Install Windows Features needed for SharePoint 2013.
Install SQL 2012 SP1.
Install all Windows Updates.
Install SharePoint 2013 SP1.
Install the same CU as you have on your other SharePoint Server.
Adding additional SharePoint Server to the Farm
http://edwardvbs.files.wordpress.com/2014/05/sharepoint-product-configuration.png?w=300&h=259Launch the SharePoint Products and Configuration Wizard. At the part to enter in the current SharePoint Server DB details the error above came up.
When opening the database of the existing server on this server from SQL Management Studio, it presented the following error:
- The target principal name is incorrect. Cannot generate SSPI context.
Solution
In Active Directory, open the computer record for the Database server. In the attribute list, the "servicePrincipalName" attribute shows the following entries:
- MSSQLSVC
- RestrictedKrbHost
Delete the two MSSQLSvc entries as well as the RestrictedKrbHost entries. Restart the Database server and the problem should be resolved.
