沒裝SQL Express怎麼玩Windows Azure
在玩Windows Azure Tools for Microsoft Visual Studio Walkthroughs的Quick Lap around the Windows Azure Tools for Microsoft Visual Studio的時候,
在執行專案時會先啟動Development Storage,
但是一啟動就會出現
“The SQL server instance ‘./Express’could not be found. Please verify that SQL Express is installed and running.”
而在我的環境中只有安裝SQL 2005 server但是沒有裝SQL Express,
而我也不想再去裝Express,
這時只要改一下設定檔DevelopmentStorage.exe.config就可以了.
檔案位置放在
C:\Program Files\Windows Azure SDK\v1.0\bin\
用編輯器開啟後,只要修改兩個地方
1. ConnectionString
<connectionStrings>
<add name="DevelopmentStorageDbConnectionString"
connectionString="Data Source=./Express;Initial Catalog=DevelopmentStorageDb;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
2.developmentStorageConfig / services / service
<services>
<service name="Blob" url="http://127.0.0.1:10000/"/>
<service name="Queue" url="http://127.0.0.1:10001/"/>
<service name="Table" url="http://127.0.0.1:10002/" dbServer="localhost/Express"/>
</services>
將上面的設定改成你的SQL Server名稱就可以了.