CODEWITHSUNDEEP
databaseazureservicestack
LakatosI
LakatosI

Reputation: 405

Accessing SQLServer from within Windows Azure

I'm working on a project with a couple of my friends on Windows Azure using ServiceStack to create a RESTful API for our service. We're using SQLAzure to save spatial data provided by the users, and then our service queries the DB, performs some calculations, and then returns a location or index. I'm suing a library my colleague wrote to communicate with the DB. Configuration settings are stored in Web.config. When I test the service locally and on the Azure emulator, everything works fine, but once our code is uploaded and running it keeps throwing exceptions whenever it tries to connect to our SQLAzure server. Are there any special configuration setting I need to include for the instance to be able to connect? I already added the local services exception to the firewall rules.

Upvotes: 1

Views: 162

Answers (1)

user728584
user728584

Reputation: 2135

One thing that caught me out before was with 'web config transform', I was updating my web.config connection string but not the web.config transform for release mode, that one took me a full day to diagnose, painful!

Upvotes: 1

Related Questions