Accessing SQLServer from within Windows Azure

Question

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.

Have you tested running locally in the emulator and pointing at SQL Azure as opposed to a local SQL Server instance? — user728584
– user728584, Commented Apr 20, 2012 at 9:44
As for the exceptions, I'm fairly new to Azure and ServiceStack, and I don't know exactly how to see the exceptions. I pin-pointed the problem down to the methods that call the database, so it must be a connection problem. ServiceStack theoretically should return through the response package any exception thrown, but in my case it just returns 0 for normal input. However, if I give it malformed data, it returns the exception as it is supposed to do. — LakatosI
– LakatosI, Commented Apr 20, 2012 at 10:38
I'm wondering if its a ServiceStack issues, logging in via RDP might give you a better indication. Have you set the ServiceStack DLL's to copy local true when you deployed it? My assumption is that your deployment is missing something that your local machine has and it has nothing to do with the connection string and all to do with ServiceStack. (Is it supported on Azure?) — user728584
– user728584, Commented Apr 20, 2012 at 11:57

user728584 · Accepted Answer · 2012-04-20 09:48:35Z

1

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!

answered Apr 20, 2012 at 9:48

user728584

2,1352 gold badges22 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

Accessing SQLServer from within Windows Azure

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related