I encountered the above problem when I released the first Windows azure application. Google knows that Azure is looking for the sqlexpress instance by default. I installed the full version of SQL Server 2008 R2, and also deliberately unload the Express version in the previous system, cup...
The solution on the Internet is to enter the azure SDK prompt, which is so vague that there are no links. So I went to the installation directory to find the solution, and finally
C: \ Program Files \ Windows azure SDK \ v1.2 \ bin> setenv
This path is found. setenv is the command line to be entered. After you press enter, you will be prompted: Windows azure SDK Shell
Because I do not have instance access, enter the following
Dsinit/sqlinstance:
If your database has an instance, follow the Instance name after the colon.
Then press Enter. In the displayed window, the progress will be displayed, and the process will be successful. Then I also saw that he added an instance to My SQL Server because I didn't give the Instance name, it is replaced by a computer name.
At this time, start debugging and pass the test smoothly.
8/21 correct: the above method still fails to connect to the database without installing SQL Server express on the local machine...