ASP.NET 5 app hosted on Ubuntu won't access Azure SQL database

Question

ASP.NET 5 app works normally on IIS and allows adding anything to database on Azure SQL Server. With same connection string, while hosted on Ubuntu , it seams it can't access database. No exception is thrown, but my table with data (that should be fetched) from database is now empty.And I can't create new row.

Even with KRE, is it possible to access Azure Sql database from ASP.NET vNext app hosted on Ubuntu ?

Community · Accepted Answer · 2017-05-23 11:59:17Z

1

I've found a solution thanks to Jsinh. It's Encrypt that caused me most of the problem, so I needed to set it to false, also, I needed to add Trusted_Connection=False in my connectionString in config.json. Thanks, Jsinh

edited May 23, 2017 at 11:59

CommunityBot

11 silver badge

answered Apr 14, 2015 at 11:35

DetectiveShmee

2251 silver badge9 bronze badges

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

Comments

NPNelson · Accepted Answer · 2015-04-05 15:56:26Z

0

I know this is a long shot, but make sure you double check that the public IP address of your Ubuntu server is allowed through the SQL Azure firewall.

answered Apr 5, 2015 at 15:56

NPNelson

3,1102 gold badges21 silver badges28 bronze badges

1 Comment

DetectiveShmee Over a year ago

I checked with person responsible for the Azure, both vm and database, when I started using Azure sql db. If we exclude that, I thought kre-mono would do the same thing as IIS and allow me to fetch data.

Collectives™ on Stack Overflow

ASP.NET 5 app hosted on Ubuntu won't access Azure SQL database

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related