Salaudeen Rajack's SharePoint Experiences!
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
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
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
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
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
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
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
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
Here are the SQL Server queries to get all SQL Server database data file and log file Size, Location: This script outputs each data file & log file of all databases. If you want to combine Data File & Log File Size: This will give you all Databases attached to a specific…
Read more
During maintenance/migrations, it’s 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 have these options available to set read only access to either SharePoint…
Read more