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, 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: