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.

Step-by-step

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: