How to Implement Responsive UI in SharePoint 2013 & 2016

Step1:

Welcome to  Designers Dairy blog , Here we are going to discuss How to Implement Responsive UI in SharePoint 2016 in  On-Premise SharePoint and office 365.

Step2:

In Earlier Days, We can't make sharepoint ribbon, content areas like  navigation, search box and content pages are not responsive in tablet and mobile views.

Step3:

To Overcome this issues.

The solution is to enable the PnP Responsive UI in Microsoft SharePoint 2013/2016 on-premises or SharePoint Online using the Power Shell cmdlet Enable-PnPResponsiveUI, and also provides you the capability to enable a custom Responsive UI for a Site Collection.

Download the files included in this solution

https://github.com/SharePoint/PnP-Tools/tree/master/Solutions/SharePoint.UI.Responsive

Step4:

To  Enable the responsive UI package, keep the files in C:Drive as shown in below screenshot.

Step5:

Give  .\Enable-SPResponsiveUI.ps1 comment to install  SP Responsive package

Ps c:\>    .\Enable-SPResponsiveUI.ps1

It will ask for Target Url :  https://xyz.sharepoint.com/sites/Mycompany

and  give the Credentials Username and password.

Step6:

Once its gets completed you will  get success message

"Responsive UI application succeeded"

Step7:

Refresh your  site collection  and check entire site will be responsiveness.

Step8:

Enjoy folks.. Stay Tune on  Webdesignersdairy for more updates on SharePoint.

A network-related or instance-specific error occurred while establishing a connection to SQL Server

Welcome to designerdairy blog, Here we are going to see how to resolve  below error when we connecting the sql server.

Step 1: 

A network-related or instance-specific error occurred while establishing a connection to SQL Server.The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1326)

Step2:

Go and open  "SQL Server Configuration Manager"

Step3 :

Click on "SQL Server Network Configuration" and Click on "Protocols for SQL Express"

Right hand side click  on "TCP/IP" (make sure it is Enabled) Click on Properties

Step4 :

Double click on "TCP/IP",  pop up dialog boxes open, there you will find two tabs  Protocols and IP Addresses

Step5 :

Now Select "IP Addresses" Tab -and- Go to the last entry "IP All"

Enter "TCP Port" 1433.

Step6:

Now go to (WinKey + r) and  type "services.msc" and restart the MSSQL$SQLEXPRESS

Step7:

The problem will get resolved. Enjoy folks Happy Coding...!