You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to connect to Microsoft Azure SQL Server Database? Do we need agent in this case as its not an o

edited Nov 12, 2017 8:00AM in Integration 1 comment

Summary

How to connect to Microsoft Azure SQL Server Database? Do we need agent in this case as its not an on premise database?

Content

Hello,

I have a requirement where I need to connect to Microsoft Azure SQL server database  in ICS for one of the integration.

I am trying to achieve this by configuring a connection of type Microsoft SQLServer. I have populated following fields in the configure connection page:

Host Name:

Port:

DatabaseName:

Username:

Password:

Now when I try to test the connection, it just hangs.

I got the IP for my cloud identity domain and added same in firewall rules in Microsoft Azure. To make sure that Database is accessible I also added my local IP to the Firewall and was able to connect to SQL server database from command prompt in my machine , so I don't see any issue at Microsoft end.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!