none
Add the connection string to your Web App

All replies

  • Thanks for using Azure! To add Connection string to your web app you can follow below steps.  Select App Services, then select the web app, then Settings, then configuration ,then application setting. Scroll down to connection strings. Click add New Connection string new window opens with name, value and type.

    For “connection strings”, there is a naming convention used to prepend the environment variable depending on the type of database you selected in the databases dropdown.

    If you select “Sql Databases”, the prepended string is “SQLAZURECONNSTR_”

    If you select “SQL Server” the prepended string is “SQLCONNSTR_”

    If you select “MySQL” the prepended string is “MYSQLCONNSTR_”

    If you select “Custom” the prepended string is “CUSTOMCONNSTR_”

    Now Open database you have created then select Overview click on connection strings then copy connection strings and paste it to value of web app> application Setting > connection String. Edit your username and your password. Click update and then save.

    You may refer to below documents

    https://docs.microsoft.com/en-us/azure/app-service/web-sites-configure

    https://azure.microsoft.com/en-us/blog/windows-azure-web-sites-how-application-strings-and-connection-strings-work/

    Let me know if you further need help.



    Thursday, May 16, 2019 3:18 AM
    Moderator
  • Hey,

    Just Checking in to see if the above answer helped. Let me know if there are still any additional issues we can help with.

     ---------------------------------------------------------------------------------------------------------------------------------

    If the above answer was helpful, kindly do ‘Mark as answer” and/or ‘Vote as helpful’ the post for benefiting the other users with a similar issue.

    Monday, May 20, 2019 5:04 AM
    Moderator