If you are working with SQL endpoints in BIS connections (such as SQL Reader and SQL Writer) you require Connection String to be able to connect the SQL database. If you are not sure how to write the connection string, this article explains how you can easily get SQL service database connection string from visual studio.
- You should know the following details of SQL Server:
- Server Name
- Username
- Password
- Database name which you want to connect
- Open Visual Studio.
- Click View, Server Explorer.
- Right click Data Connections, Add Connection.
- On the Add Connection window, fill in the relevant details such as Server Name and Select or enter a database name.
- Click on Test Connection button. If you submit the correct credentials, you will get the Test connection succeeded confirmation message.
- Now your connection is working successfully so, now click on Ok button. You will get one data connection under Data Connections.
- Right click on your connection and click Properties.
- You will get properties window of your connection. Find Connection String property and copy the connection string.
- Paste and use this connection string in properties of SQL Reader and SQL Writer endpoints.
Please note that we have used Visual Studio 2013, as an example, to find the SQL connection string in this article.
Dynamics NAV Integration Insights from the Experts 
Pingback: Creating Import Connection Using SQL Integration | Dynamics NAV Integration Insights from the Experts
Hi Paresh. I have a muck quicker way to get the connection string. Create a new Text Document on your desktop. Change the file extension from .txt to .udl. Open the file and you can configure and test the connection. Save and open the file in Notepad to get the connection string. Within 10 seconds without the need of Visual Studio.
Pingback: Learn how to create an import connection using SQL Server integration with Business Integration Solutions for Microsoft Dynamics NAV - To-Increase