Entity Framework ASP.NET WEB API on remote server

asp.net-web-api c# entity-framework-6

Question

My WEB API EF6 has been set up on a distant IIS server. Failure to connect to the remote database serverdb.Database.Exists() returns false . While on my local PC, everything is functioning normally and allowing me to connect to the DB anddb.Database.Exists() returns true .

What adjustments to make to the ConnectionString. This is how my connectionstring appears:

<add name="myconnstring" connectionString="metadata=res://*/Models.InformationSystem.csdl|res://*/Models.InformationSystem.ssdl|res://*/Models.InformationSystem.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=server01;Initial Catalog=myDB;Persist Security Info=True;User ID=abcd;Password=abcd;initial catalog=myDB;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient"/>
1
0
9/27/2018 5:19:25 AM

Popular Answer

ZZZ_tmp
0
9/27/2018 1:00:41 AM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow