I am new to Azure and I am trying out my first website on Azure. I have successfully migrated a TEST website to Azure on my local computer with the help of few MSDN documents and forums.
The website was tested on the cloud environment with the help of Emulator. I have also published the TEST Azure project and generated the two files, TEST.cspkg and ServiceConfiguration.cscfg.
I then created an account on Windows Azure and uploaded these two files to the compute environment. For migrating the database tables and data from the developement computer, I used the SQL Azure Migration Wizard. I was successful in creating TSQL file for
the required tables and also migrate the respective data using bcp to the tables in the Azure database also.
The problem that I have facing now is, the TEST website is unable to access the data in Azure database. However on my development computer, on the emulator, the website runs well (compute emulator and storage emulator is started and the website functions
properly with proper database access when required). Can I please know the CHANGES or ADDITIONS required for the website to access the Azure database. I also want to know if connection strings are required exclusively for the same. If YES, how and where do
I do it using VB.
Thank you very much in advance :)