配置SQL Server Instance for Azure Development Storage

症状:

安装了Azure SDK后,新建一个Web Role,F5启动程序,弹出一个Storage Emulator Initialization对话框显示以下错误信息:

==============================================

Attempting to use server specified.

User specified an instance through /server or /sqlInstance options.

Probing Failed. Retrying probe for localDB

Probing SQL Instance: '(localdb)\v11.0'.

==============================================

原因:

没有配置本地SQL Server信息。

解决方案:

1. 打开Windows Azure Command Prompt。

2. 运行命令dsinit /sqlInstance:your instance name

此后会弹出Storage Emulator Initialization对话框显示以下信息

==============================================

Added reservation for http://127.0.0.1:10000/ in user account username.

Added reservation for http://127.0.0.1:10001/ in user account username.

Added reservation for http://127.0.0.1:10002/ in user account username.

Attempting to use server specified.

User specified an instance through /server or /sqlInstance options.

Probing SQL Instance: '.\SQLExpress'.

Found SQL Instance .\SQLExpress.

Creating database DevelopmentStorageDb201210 on SQL instance '.\SQLExpress'.

Granting database access to user username.

Database access for user username was granted.

Initialization successful. The storage emulator is now ready for use.

==============================================

此时再F5,Azure project就可以工作正常了。

原文地址:https://www.cnblogs.com/lilideng/p/SQL_Azure_Development_Storage.html