Hi All,
I am getting the below error when trying to install membership provider on the AZURE database.
Exception:
An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 40508 and the SqlException message is: USE statement is not supported to switch between databases. Use a new connection to connect to a different Database.
Have gone through a similar post in this forums which suggest an alternate approach of installing SQL scripts for AZURE. But the links provided in the below post to download the scripts are dead.
http://forums.asp.net/t/1892284.aspx?Unable+to+install+membership+in+SQL+azure+database+
Below links to download scripts for AZURE are not active.
http://archive.msdn.microsoft.com/KB2006191/Release/ProjectReleases.aspx?ReleaseId=3539
http://msdn.microsoft.com/en-us/library/windowsazure/hh508981.aspx
https://support.microsoft.com/kb/2006191
Also gone through a blog that suggest to make use of ASP.NET Universal provider for SQL AZURE. Just wanted to quickly check if there are any other alternative for this before proceeding with the below universal provider.
Another option that i tried was to use the SQLAzureMW tool that would help in migrating the SQL Server 2005/2008/2012 databases to Azure SQL Database, but it didnt help either
http://sqlazuremw.codeplex.com/
Appreciate your help, suggestions in getting this res