CODEWITHSUNDEEP
sqlms-accessazurefirewallms-access-2013
marcus.d.johnson
marcus.d.johnson

Reputation: 43

Accessing Azure SQL Database from Access (without port 1433)

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

Upvotes: 2

Views: 1299

Answers (2)

Warlord
Warlord

Reputation: 47

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.

Upvotes: 0

dascalos
dascalos

Reputation: 509

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/

Upvotes: 1

Related Questions