"The provider did not return a ProviderManifestToken string." error happened

Question

I deploy a project, it is OK　ｉｎ　ａｚｕｒｅ　ｌｏｃａｌ　ｅｍｕｌａｔｏｒ，　ｂｕｔ　ｉｔ　ｗｅｎｔ　"The provider did not return a ProviderManifestToken string." error in cloudy.

I used Entity Framework in it, but why emulator is OK, cloudy is wrong?

Answer 1

from log ....I used Sqlazure , and I can connect it from local

Cannot open server '********' requested by the login. Client with IP address '***.***.***.***' is not allowed to access the server.  To enable access, use the SQL Azure Portal or run sp_set_firewall_rule on the master database to create a firewall rule for this IP address or address range.  It may take up to five minutes for this change to take effect.
Login failed for user '***'.
This session has been assigned a tracing ID of '********************'.  Provide this tracing ID to customer support when you need assistance.

Answer 2

Hi,

It seems that SQL Azure Firewall settings are not setup for you. Please follow the link: http://msdn.microsoft.com/en-us/library/windowsazure/ee621783.aspx for the same.

I hope it helps!!

---

If you found this post useful, Please "Mark as Answer" or "Vote as Helpful". Thanks! Vaibhav Gujral.

Answer 3

I had forgotten that I changed Windows Azure SQL Database password a few days ago and this was causing this error when Today I tried to publish the app again through Visual Studio 2012 RC. I just had to update my connection string with the new password and everything started working again.

Hope it helps,

Leniel

---

Leniel Macaferi http://leniel.net