How to Check SQL Server Connectivity from SharePoint?

How do I quickly check SQL Server connectivity from the SharePoint server? Well, you can use Telnet. telnet {SQL-Server-Name or IP} 1433 If your SQL Server listens on a different port, change the default port 1433 accordingly. Using PowerShell to test SQL server connectivity:You can also use PowerShell to check if SharePoint…

Read more

Set Max Degree of Parallelism for SharePoint 2013 in SQL Server 2012

What is max degree of parallelism in SQL Server? SQL Server configuration option ‘max degree of parallelism’ limits the number of processors used for the execution of a query with a parallel plan. By default, it’s set to ‘0’ to allow all processors available. SharePoint 2013 requires that the “max degree of…

Read more

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

Problem: 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…

Read more

Create SSRS Report from SharePoint 2013 List using Report Builder 3.0

Reporting Service integrated with SharePoint provides a rich reporting platform. Lets see how we can create SQL Server reporting services report from SharePoint list data: Create a Library for Reports and add Report Content Type To start with, Lets create a Document Library,  Add Report Builder Report content type to create a…

Read more

How to Create and Deploy SSRS 2012 Reports to SharePoint 2013?

Reporting Services integrated with SharePoint 2013 gives you Rich enterprise reporting features. We’ve our SQL Server 2012 Reporting services integrated with SharePoint 2013 already. So now we can create reports for SharePoint 2013 using both SQL Server Report Builder 3.0 and using Visual Studio. Lets create a SQL Server Reporting Services Report…

Read more

Configure SQL Server Reporting Services (SSRS) 2012 Integration with SharePoint 2013 – Step by Step Guide

This implementation guide walks through step by step on configuring SQL Server Reporting Services 2012 Integration with SharePoint 2013. What’s New in SSRS 2012 with SharePoint 2013? Unlike its previous versions, SSRS 2012 with SharePoint 2013 installation & configuration has been greatly simplified.  There are lots of changes in installing & Configuring…

Read more

Fix SharePoint “Cannot connect to the configuration database” Error

Problem: Users received “Cannot connect to the configuration database” error when trying to access SharePoint sites! Reason: SQL Server services were stopped during a patch installation. (In another case, SQL Server service stopped due to disk space issue!). Solution: Start SQL Server Service! Go to SQL Server Configuration Manager Right click on…

Read more

How to Run SQL Server Query from PowerShell Script?

For a migration project, there was a requirement to read from SQL Server table data , process the migration and then insert / update the tables back from PowerShell. We got to run SQL Server query from PowerShell. Here is how to query SQL Server using PowerShell: PowerShell to Run SQL Server…

Read more

Set SharePoint Web Application or Farm to Read Only Mode

During maintenance/migrations, its inevitable to set the entire SharePoint Farm or at least Web Applications to read-only mode for some time. SharePoint doesn’t provide any direct ways to set the entire web application or Farm to Read-only mode, but we’ve these options available to set read only access to either SharePoint Web…

Read more