Deploy the default MVC 4 template to windows Azure

[imilledge]

I am very new to Windows Azure and am tinkering with it to learn how it works. To keep things as simple as possible, I am trying to deploy the default MVC 4 template that is generated by VS 2012 Express for web. I created a new project - an Azure cloud service. I selected an MVC 4 web role. And that creates a nice little asp.net application with home, about and contact pages, and links to register and login. I just want to deploy this site to Azure and see it work on the cloud. However the membership does not appear to work on azure. The pages of the application appear correct. However when I click the 'Register' link it does not take me to a page to nter a new username and password. I do not believe the membership tables are being generated anywhere either. Considering how simple this is, I think I must be making a silly mistake somewhere. I would really appreciate if someone could help me with this.Also, for the record, I have noticed that if I create a stand alone MVC 4 project in VS2012 Express (as opposed to a Windows Azure Cloud service project with an mvc 4 web role) then when I right click that MVC4 project and choose to publish it, it allows me to specify a sql database using a connection string. What is more is once it is published to Azure, the membership works perfectly. I can create useraccounts and log in. If I examine my SQL Azure database using the azure portal, I can see the new membership tables created there. But when I try to publish a Windows Azure Cloud service with MVC4 webrole, I do not see any option to provide a connection string of any sort to the azure project. Maybe that is why the membership is not working... since there is no database linked with the web role... but I cannot figure out how to specify this. I was under the impression that publishing a stand alone MVC4 project to Azure, and publishing an Azure Cloud Service with an MVC4 Web Role is the exact same thing, please correct me if I am wrong. And either way, I should be able to see the membership functionality of my mvc 4 web role.Here are the steps to recreate what I have. Basically it is all default stuff: [*]Create a new project in VS2012 Express File -> New Project -> 'Windows Azure Cloud Service'.[*]On the next screen add an ASP.NET MVC 4 Web Role to it. [*]On the subsequent screen choose 'Internet Application'.These 3 steps create a new project. It runs locally just fine.Now I try to put it on the cloud.[*]Right click on the windows azure project in solution explorer and choose 'Publish'.[*]Choose the subscription (I already have certificate/credentials in place to publish to azure from VS so I select that)[*]Create a cloud service on the next screen (I name it 'garyazurecloudservice').[*]Accept all the default settings in the Publish wizard and click Publish.The publishing process takes a few minutes. The web application can be viewed at http://garyazurecloudservice.cloudapp.net/.The Home, About and Contact pages all display correctly. However it I click the 'Register' link at the top right I see a webpage with the correct layout template, but an error in red that says: "Error. An error occurred while processing your request."I have tried to create an SQL database on Azure but I don't see any way to connect this role to it. Possibly that is the problem? Or maybe it is something else altogether. I would appreciate if anyone can tell me what is wrong. I have spent the entire day googling and going in circles with no success. Thank you for any help you can provide. Gary