Install SQL Server 2016 Reporting Service in SharePoint Server 2016 Farm

Overview Reporting services are one of the very cool tools of SQL Server 2016. In this new version of the product, you can find several improvements in the tool. The first innovation I see is the visual format. The second is the improvement of the tools to customize reports at server and mobile level and… Continue reading Install SQL Server 2016 Reporting Service in SharePoint Server 2016 Farm

Disable Loop Back Check in Windows Server

Microsoft has introduced a security feature in 2003 Server to prevent attacks on Windows servers. This feature will prevent a web application access from the host server with a fully qualified domain name. During the SharePoint installation this is one of the issues that needs to be addressed. There are two approaches to disable loop… Continue reading Disable Loop Back Check in Windows Server

How to repair a suspect DB in MSSQL

Issue You have a database in MS SQL that is tagged as (suspect) and you are unable to connect to the database. Possible Causes The database could have become corrupted. There is not enough space available for the SQL Server to recover the database during startup. The database cannot be opened due to inaccessible files… Continue reading How to repair a suspect DB in MSSQL

The program w3wp.exe, with the assigned process ID, could not authenticate locally by using the target name HTTP/WEBSITENAME

You may face this error when you are running your development environment on virtual server where you have also configured alternate access URL-s.The full message is something like this: “The program w3wp.exe, with the assigned process ID, could not authenticate locally by using the target name HTTP/WEBSITENAME. The target name used is not valid. A target… Continue reading The program w3wp.exe, with the assigned process ID, could not authenticate locally by using the target name HTTP/WEBSITENAME

Update the Service-Communications SSL certificate of ADFS and WAP servers

Changing the Service-Communications certificate for the Windows Server 2012 R2 ADFS servers and Windows Server 2012 R2 Web Application Proxy servers is sometimes tricky if you are not familiar with the technology. This script is not intended to be used for ADFS on Windows Server 2016. Basically you need to perform 3 operations: Change the… Continue reading Update the Service-Communications SSL certificate of ADFS and WAP servers