search

MicrosoftEdge / enterprise-mode-site-list-portal

Other
52 stars 24 forks source link

Connection string issue with azure sql server #25

Open andreespin opened 3 years ago

andreespin commented 3 years ago

I'm having an issue to connect to an azure sql, the application was deployed but we can't see the roles when we try to register an user. Is anyone using az sql and can send us the connection string to comparison?

DanielUlisses commented 3 years ago

I upgraded the entire project to target the .net 4.7.2 and added the conditional compilation symbol to net472 in all parts of the project

then I updated the connection string based on https://azure.microsoft.com/en-us/blog/securing-azure-sql-databases-with-managed-identities-just-got-easier/

as the module requires the .net 4.7.2 it may be the issue you have

image

the connection string now look like:

<add name="LOBMergedEntities" connectionString="metadata=res://*/EMIEDataModel.csdl|res://*/EMIEDataModel.ssdl|res://*/EMIEDataModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=tcp:<servername>.database.windows.net,1433;Initial Catalog=EMIEDatabase;UID=a;Authentication=Active Directory Interactive;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />