How to Connect SQL Server 2012 when Configuring Data-Viewer Web Part
When configuring data in the tool pane of the Bamboo Data-Viewer Web Part with a connection to a Data Source in a SQL Server Table or View, you will see two options for this function:
1. Current Login Account – Standalone Deployment
2. Login Account – Remote SQL Server
I select the Login Account – Remote SQL Server option and, although I have configured all conditions exactly, it cannot connect to the database. You will see a big error show up in the tool pane as pictured below:
This article will guide you on how to remote into SQL server 2012 when configuring Data-Viewer Web Part.
First, go to the Microsoft SQL Server program, and right-click on the root node. Select the Security tab, and check the Failed logins only radio button.
Click the OK button:
Next, go to the SQL Server Configuration Manager.
Select SQL Server Services, and make sure that the SQL Server (MSSQL SERVER) is running automatically:
Under SQL Native Client node, select Client Protocols and enable for Shared Memory, TCP/IP, and Name Pipes:
Under SQL Server Network Configuration node, select Protocols for MSSQL SERVER -> enable for Shared Memory and Name Pipes:
Under SQL Native Client 11.0 Configuration, select Client Protocols and enable for Shared Memory, TCP/IP, and Name Pipes:
Finally, go back to the Data-Viewer tool pane, and then connect to SQL with the Custom Login Account – Remote SQL Server.
After clicking the Load Databases button, you will see that Database Name and Table Name have loaded:
Now, we can see data displayed on the Web Part as pictured below:
The cloud parts are functional components that extend your SharePoint Online environment in Microsoft 365.
Supports Classic and Modern sites for SharePoint Online/Microsoft 365
Small Business Pricing and Discounts
These web parts extend SharePoint beyond its out-of-the-box capabilities by tailoring it to your requirements with Bamboo Solution’s growing portfolio of SharePoint Web Parts.
SharePoint 2016, 2019, 2022 – Classic Pages Only
Our team of Microsoft 365 Technology Consultants helps you get the most out of your Microsoft technology, we have the best Microsoft 365 talent to streamline your organization.
Consulting to Streamline Your Department