Loading

How to pass Local SQL Connection String to Azure

pradeep shukla

Hi All,

Can you please guide me on a Webjob which get data from Local SQL server to Azure. The problem is with the Connection String which I created for local is not authorized for AZURE but when we run The console application it works properly but when I schedule the Zip file of that Console through WebJob it throws an exeption.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nanddeep Nachan8y ago
Try the hybrid connection as explained here:
https://docs.microsoft.com/en-us/azure/app-service/app-service-hybrid-connections
0
Anurag Sharma8y ago
1. Log in to the Azure portal.
2. Select SQL Databases from the left-hand menu, and click your database on the SQL databases page.
3. On the Overview page for your database, review the fully qualified server name as shown in the following image. You can hover over the server name to bring up the Click to copy option.
  Download the picture to see.....
4. If you forget your server login information, navigate to the SQL Database server page to view the server admin name. If necessary, reset the password.
+1