SQL Azure Connection

Discussion in 'ASP.NET 4.5 Beta [Closed]' started by Kartin Melly, Jun 17, 2012.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Kartin Melly

    Kartin Melly

    I seem to be unable to connect my website to a SQL Azure database over tcp, port 1433. Is this possible from the sandbox???
    It would be great if its possible as I really need it.

    Many Thanks
     
    Kartin Melly, Jun 17, 2012
    #1
  2. Kartin Melly

    Kartin Melly

    Finally got it sorted

    Connections to SQL Azure are indeed supported from the sandbox!!

    I had a couple of issues to resolve first though which may help someone.

    Even though my connection string was pointing to my SQL azure database, when I published my web app from visual studio (12) it seemed to pick up an older version of the web.config that was pointing to a local database. I couldn't figure out what was going on for a while.
    To fix I simply ran "Clean Solution" followed by a full rebuild and publish. This published the correct web.config

    Note: I then got an error saying that azure was blocking my discountasp hosting server. This can be set by logging into Azure and setting a new firewall rule to accept requests from this server.

    All sorted and working.. Excellent :D
     
    Kartin Melly, Jun 18, 2012
    #2
  3. mjp

    mjp

    That's cool. Thanks for posting the follow up.
     
    mjp, Jun 18, 2012
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page