I have an Azure Function app that I have created locally. I have used the following connection string to access my local database which works fine.
public static string connectionString = "Server=KP133\\SQLEXPRESS;Initial Catalog=DBName;User ID=sa;Password=myPass";
Now I have published my application on Azure and want to access an on Premise DB with Azure On-Premise Data Gateway which is already configured by my client.
So now I am not sure how to modify my connection string so I can access the on premise database with Data Gateway as all the help available online is either for connecting Azure Functions with hybrid connection or connecting to on-preimse gateway with logic apps.
Credentials for example:
- On-Premise Gateway machine name:
MSS-SVR01 - Database Name :
MyDB - User Name :
MyUser - Password :
MyPass - On Prem Server IP :
XX.X.X.X
The on-premise database is running on SQL Server 2019 Express.