Azure SQL database working when running locally but not when published to Azure

Question

My problem is very similiar with this problem on SO, but not quite.

When i connect to my azure database locally, it runs perfectly. But when i deploy to Azure, it seems it cannot connect to the database. I'm using Entity Framework 5 code first, and i have also set copy local:true on the EF 5 reference.

These are my connection strings:

    <add name="api" connectionString="
    Server=tcp:[hidden].database.windows.net,1433;Database=API;
    User ID=[hidden]@[hidden];
    Password=[hidden];Trusted_Connection=False;
    Encrypt=True;Connection Timeout=30;
    PersistSecurityInfo=True;" providerName="System.Data.SqlClient" />

    <add name="Membership" connectionString="
    Server=tcp:[hidden].database.windows.net,1433;
    Database=Membership;User ID=[hidden]@[hidden];
    Password=[hidden];Trusted_Connection=False;
    Encrypt=True;Connection Timeout=30;
    PersistSecurityInfo=True;" providerName="System.Data.SqlClient"/>

I added

    <customErrors mode="Off"/>

in my web.config file so i could see the stacktrace, and these are the exceptions i got:

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
[InvalidOperationException: The ASP.NET Simple Membership database could not be initialized. For more information, please see http://go.microsoft.com/fwlink/?LinkId=256588]
[ProviderIncompatibleException: An error occurred while getting provider information from the database. This can be caused by Entity Framework using an incorrect connection string.

When reading the stacktrace, it is certain that the problem is that i can't initialize the membership database. This have to be a Azure deploy issue, but i can't seem to figure it out..

EDIT:

The API-database is now working, but the membership gives the same error. I scaled the web site to be reserved instead of shared. Don't know if that could have any impact.

FIXED:

Well this is just strange.. Suddenly the web site has connection with both databases. Didn't do anything other changing the server from Shared to Reserved..

Am assuming you've set the SQL Azure firewall to allow Windows Azure Services? — JuneT
– JuneT, Commented Mar 7, 2013 at 15:21

hhaggan · Accepted Answer · 2013-03-07 20:47:39Z

3

Check the IP rules made on Windows Azure portal and make sure your current IP address is within the range you allowed to access the database running on Windows Azure

answered Mar 7, 2013 at 20:47

hhaggan

6194 silver badges11 bronze badges

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

1 Comment

Are Almaas Over a year ago

I did. And to test, i even added ip address from range 0.0.0.0-255.255.255.255. Still didn't work :(

viperguynaz · Accepted Answer · 2013-03-07 18:22:29Z

0

Make sure that your IP address is in the list of allowed IP addresses for the database.

answered Mar 7, 2013 at 18:22

viperguynaz

12.2k4 gold badges33 silver badges43 bronze badges

1 Comment

Are Almaas Over a year ago

Referring to the above comment :)

Collectives™ on Stack Overflow

Azure SQL database working when running locally but not when published to Azure

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related