What database name and schema do we need to create for the default code setup by the template to access the database?

I have verified (via SQL Server Management Studio) that I can connect to the database with the same credentials.

I get the error below server side when accessing the "sql azure data" pivot:

System.Data.ProviderIncompatibleException was unhandled by user code
Message=The provider did not return a ProviderManifestToken string.
Source=System.Data.Entity

Hi the error relates to your connection string, make sure you have a valid connection string for your enviroment

I had forgotten that I changed Windows Azure SQL Database password and this was causing this error... I then updated my connection string with the new password and everything started working again.

Hope it helps,

Leniel