Ignition connection to Azure SQL Database

Ignition
1

Hi,

I’m having trouble connecting to an Azure SQL database from a separate Igniton server. This is how I set it up:
Microsoft SQLServer JDBC Driver
Connect URL: jdbc:sqlserver://SQL server name.database.windows.net
Username: SQL user name
databaseName=Existing database in SQL server

What should I use as the instanceName?
Do I also need to allow port 1433 or 1434 as a firewall outbound rule on the Ignition server?
I can connect to the database via SQL management studio on the Ignition server, so the Azure SQL server is allowing connections from the Ignition server.

Thanks!
JT

1 Like
2

Haha I just dealt with this the other week. It’s your user name.

username needs to be in the format of: username@hostname

username@SQL server name.database.windows.net

2 Likes
3

Oh great! @Paullys50 Thanks for your reply! It’s working for me now.

Some updates:
Connect URL: jdbc:sqlserver://SQL server name.database.windows.net:1433 (no , port optional)
Username works without the “.database.windows.net” as well
No port configuration required on the Ignition server

Cheers,
JT

4 Likes
4

Thanks Again Paully (im on plctalk.net as well)

I found that azure gives a good JDBC Connection string to start with in the portal you can get them.
thought i would add that for anyone else.