Monday, March 3, 2014

SharePoint Products Configuration Wizard Failed to Connect to the Database Server.

Symptoms:
SharePoint sites crashed suddenly! Found event id 5586 "The target principal name is incorrect. Cannot generate SSPI context." logged in SharePoint servers.

Tried running SharePoint 2013 Products configuration wizard. Received error message:
"Failed to connect to the database server. Ensure the database server exists, is a Sql server, and that your have the appropriate permissions to access the server."

Failed to connect to the database server. Ensure the database server exists, is a Sql server, and that your have the appropriate permissions to access the server.
Troubleshooting tried:
  • Verified the Network connectivity, Port open in database server (Netstat -a -n -o)
  • Made sure Firewall is disabled. TCP/IP, Named Pipe protocols are enabled in SQL Server.
  • Verified the SQL Server service is up and running
  • Verified all required permissions to connect with SQL Server. Made sure no service account is locked. Tried restarting the services and server.
  • But when tried establishing a connection to SQL Server as in How to Check SQL Server Connectivity from SharePoint, it failed!
The Final solution Worked for me:
  • Go to your Active Directory >> Under Computer node, select your SQL Server >> Right Click >> Properties
  • Click on "Attribute Editor" tab, Edit "ServicePrincipalName" attribute
  • Remove these two highlighted entries which starts with "MSSQLSvc" 
  • Restart your database server.



You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Check out these SharePoint products:

No comments :

Post a Comment

Please Login and comment to get your questions answered!

You might also like:

Related Posts Plugin for WordPress, Blogger...