Accessing Azure SQL Database from Access (without port 1433)

Question

So I'm building a pretty simple application in Access 2013, and our company recommended using Azure SQL Database for the backend (due to the cost and simplicity of setting up/maintenance). However, their recommendation left us with a massive problem. Port 1433 is blocked on our company's network, and it's such a big company, I can't get it unblocked.

I don't know too much about having a middle-tier, but what are my options here? Is there a simple way to connect to the database without accessing this port?

Thanks

Which server? The back-end for this application will be in Azure only. Servers for internal LAN are on-premise, but global company-wide policies dictate that port 1433 cannot be opened. — marcus.d.johnson
– marcus.d.johnson, Commented Nov 25, 2014 at 11:12
Not sure why your company group policy blocks SQL port 1433. you have two option, either unblock the port or find another db server and host it locally OR ask your azure hosting if they can change the port — Krish
– Krish, Commented Nov 25, 2014 at 11:45
Apparently it's because of the SQL Slammer worm. Seriously annoying as they recommended this service in the first place, and obviously didn't think we'd want a direct connection — marcus.d.johnson
– marcus.d.johnson, Commented Nov 25, 2014 at 11:56
re: Slammer - That was almost 12 years ago. Your IT people sure do hold a grudge. — Gord Thompson
– Gord Thompson, Commented Nov 25, 2014 at 12:04

dascalos · Accepted Answer · 2014-11-25 11:31:16Z

1

You could fire up a Azure VM with SQL Server already installed. Then you should be able to change the ports to your liking.

Check out this post...

http://roberteichenseer.wordpress.com/2012/07/06/nderung-default-port-sql-server-innerhalb-einer-azure-vm/

answered Nov 25, 2014 at 11:31

dascalos

5094 silver badges15 bronze badges

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

1 Comment

marcus.d.johnson Over a year ago

That's true, but the problem is that it's only a small application or a handful of users. The price/maintenance of a VM just isn't feasible given the scale.

Genhis · Accepted Answer · 2019-07-10 02:06:01Z

0

You only need to open up 1433 outbound in your works firewall not the 1433 inbound.

Most security teams are ok to open the outbound port. Opening the outbound will give you the access to connect and access the data inside Azure.

edited Jul 10, 2019 at 2:06

Genhis

1,5243 gold badges27 silver badges33 bronze badges

answered Jul 9, 2019 at 23:52

Warlord

471 silver badge11 bronze badges

Collectives™ on Stack Overflow

Accessing Azure SQL Database from Access (without port 1433)

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related