沒裝SQL Express怎麼玩Windows Azure

沒裝SQL Express怎麼玩Windows Azure

在玩Windows Azure Tools for Microsoft Visual Studio WalkthroughsQuick 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名稱就可以了.

 

參考網址 : http://www.developerfusion.com/community/blog-entry/8389092/azure-development-storage-for-those-without-sql-express/