Can I connect to a Azure SQL database from ASP.NET application hosted in IONOS

Question

Can I connect to a Azure SQL database from ASP.NET application hosted in IONOS

Cristopher Aguilera 91

Good morning,

I have a Web Forms application currently hosted in IONOS which connects to a SQL database within IONOS as well. I have now created a new database within the Azure platform and I would like to connect to my SQL database (in azure) from my IONOS app. Is this possible?

Thanks in advance!

Kind regards,
Cris

B B 0 Reputation points

2024-02-19T02:31:12.4366667+00:00

Were you able to get this to work? I also have the same issue

1 answer

Your answer

B B 0 Reputation points

2024-02-19T02:31:12.4366667+00:00

Were you able to get this to work? I also have the same issue

Answer 1

Alberto Morillo 34,671 MVP Volunteer Moderator

Based on this IONOS article you can connect to a SQL Server database using System.Data.SqlClient. The following example shows a connection string for SQL Database using System.Data.SqlClient.

<add name="ConnectionStringName"
    providerName="System.Data.SqlClient"
    connectionString="Data Source=tcp:ServerName.database.windows.net,1433;Initial Catalog=DatabaseName;Integrated Security=False;User Id=username@servername;Password=password;Encrypt=True;TrustServerCertificate=False;MultipleActiveResultSets=True" />

The TrustServerCertificate=False setting is recommended to help protect against man-in-the-middle attacks.

Cristopher Aguilera 91 Reputation points

2021-11-22T16:41:55.537+00:00
Hi Alberto,

Thank you for the prompt response! I used the connection string above (including my user credentials) initially and it works... but ONLY on my local machine.

These are the steps I took which lead me to successfully connect to Azure SQL:

1.- I created a new ASP.NET project from scratch,

2.- Added the connection string to the web.config file

<add name="azure-live" connectionString="Data Source={myservername},1433;Initial Catalog={My db name};User ID={my user id};Password={my password};Encrypt=True;TrustServerCertificate=False;MultipleActiveResultSets=True" providerName="System.Data.SqlClient" />

3.- Added code in Default page to call sql and get some data like: (just to test it can actually connect to the DB)

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["azure-live"].ConnectionString);

conn.Open(); DataTable data = new DataTable(); string sqlCommand = "SELECT * FROM [{my_dbname}].[{schema}].[{my table name}]"; SqlCommand cmd = new SqlCommand(sqlCommand, conn); SqlDataAdapter adp = new SqlDataAdapter(cmd); adp.Fill(data); conn.Close();

Following the steps above, it works fine! The problem is when i deploy my application to my IONOS web space, i get the following error:

A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

I hope the error message above is of any help!

Thanks for your help again!
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator

2021-11-22T17:21:48.587+00:00

Cristopher,

Please make sure you added an entry on Azure SQL firewall related to the IP or IPs used by your IONOS web spaces. See here documentation.
Cristopher Aguilera 91 Reputation points

2021-11-22T18:03:34.433+00:00

Thanks Alberto, i've added some of the IP addresses i've been able to find in IONOS. After several attempts it still didn't work.

I got in contact with the IONOS team and they could confirm that they don't allow outgoing communication on TCP port 1433 unfortunately! I don't suppose there's a way to change the port SQL server listens to in Azure?

I might have to desist on hosting my app on IONOS if i cannot connect to my Azure SQL...

Thanks,
Cris
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator

2021-11-22T19:35:07.813+00:00

It seems they support Site-to-site VPN with Azure, as you can read here.
Cristopher Aguilera 91 Reputation points

2021-11-23T07:29:51.01+00:00

Thanks for following this up Alberto! I'll give it a go this morning.

Thanks for your help, it is much appreciated.
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator

2021-11-23T10:38:25.873+00:00

Hope it works. Have a good day!
Saurabh Sharma 23,846 Reputation points Microsoft Employee Moderator

2021-11-30T19:20:51.293+00:00

@Cristopher Aguilera Please let us know if you find above reply useful. If yes, do click on 'Mark as answer' link in above reply. This will help other community members facing similar query to refer to this solution. Thanks.
Cristopher Aguilera 91 Reputation points

2021-12-01T08:59:45.703+00:00

Good morning,

Apologies for the delay on getting back to you guys. Unfortunately I wasn't able to follow the steps in the last link provided by Alberto as I don't have access to ProfitBricks and in the Ionos documentation it is not very clear how yo set up an account in order to be able to follow up the documentation. I'm sure the link provided by Alberto will work for those with access to ProfitBricks and are familiar with the environment!

I've given up on trying to connect my ASP.NET app hosted in IONOS to my Azure SQL as it seems almost unachievable or there are too many steps involved for something that should be easy and straight forward. If IONOS allowed outgoing communication on TCP port 1433 (in a shared hosting contract) this wouldn't be a problem.

Thanks for all your help and support! It is comforting to know that there's a big community out there willing to support not very experienced people like myself!

Thanks :)
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator

2021-12-01T14:55:33.527+00:00

You are always welcome on Microsoft QA forums. Have a great day!

Share via

Can I connect to a Azure SQL database from ASP.NET application hosted in IONOS

1 answer

Your answer