Issue 1 - Problems with the aspnet_regsql tool:
The aspnet_regsql.exe tool will fail to run against a SQL Azure database. When trying to create a database with the aspnet_regsql.exe tool, the user will encounter one of the following errors:
An error occurred during the execution of the SQL file 'InstallSqlState.sql'. The SQL error number is 40510 and the SqlException message is: Statement 'CREATE DATABASE' is not supported in this version of SQL Server.
-- or –
An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 208 and the SqlException message is: Invalid object name 'master.dbo.sysdatabases'.
Issue 2 - Asp.Net Session State Management:
A user’s session will not expire if the ASP.net web application uses a SQL Azure database for session state management.
Cause 2 -Asp.Net session expiration functionality is implemented through stored procedures that are scheduled through jobs in SQL Server. SQL Agent manages these jobs. However, SQL Azure databases do not support SQL Agent.
· Membership – InstallMembership.sql
· Personalization – InstallPersonalization.sql
· Profile – InstallProfile.sql
· Roles – InstallRoles.sql
· SQL Web Event Provider – InstallWebEventSqlProvider.sql
Note: You may receive the following message while executing the scripts: "Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information schema, sys, or yourself." This message can be ignored.
The workarounds provided here do not work for ASP.Net SQL Session State Management features. Microsoft does not support SQL Session State Management using SQL Azure databases for ASP.net applications.
There is a modified aspnet_regAzure.exe tool that is available for use. You can download this tool (aspnet_regsqlazure.zip) from here. This tool only supports configuring a SQL Azure database for certain Asp.net features. This tool does not support all the functionalities of aspnet_regsql.exe, and it is not supported by Microsoft.
You can find more documentation on Guidelines and Limitations for SQL Azure databases here.