Azure deployment connection string

Question

New to Azure and have difficulty to connect DB with webapp. I am playing with a demo project using entityframework and code first mitigation. It works as expected in my local computer and localdb. But it does not work when I try to deploy it to Azure. I use the Webapp and a SQLDatabase in Azure. Then, I try to connect them using connection string in Webconfig.

  <add name="DefaultConnection" connectionString="Server=tcp:dritor.database.windows.net,1433;Database=dritorDB;User ID=****@dritor;Password={****};Encrypt=True;TrustServerCertificate=False;Connection Timeout=30" providerName="System.Data.SqlClient" />

The homepage shows up as expected. But when I try to fetch data from DB (I put some data with seed), it returns something as follows:

This XML file does not appear to have any style information associated with it. The document tree is shown below.

 <Error>
  <Message>An error has occurred.</Message>
  </Error>

I suspect that I made the connectionstring wrong but I am not sure. Any suggestions on how to debug in this situation would be appreciated.

The string looks correct except for the curly braces around the password. It should just be Password=**** — Bryan Lewis
– Bryan Lewis, Commented Mar 27, 2016 at 0:28

Bryan Lewis · Accepted Answer · 2016-03-27 00:36:25Z

2

The string looks correct except for the curly braces around the password. It should just be Password=****

answered Mar 27, 2016 at 0:36

Bryan Lewis

6,0484 gold badges42 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Azure deployment connection string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related