2011年5月21日 星期六

SQL Azure - 2

1. Rebuild SQL Azure Account. (tried too many times in the wrong password and typo second mail address)
2. Follow the Ex3-BuildingSQLAzureApp steps.
    a. Create a database as HolTestDB
    b. Employ SQL 2008 management Studio to implement tables
        copy AdventureWorks2008LT_Azure.sql to excute

    c. Add connection string
 <add name="AdventureWorksLTConnectionString" connectionString="Server=tcp:ydxpy7fu4v.database.windows.net,1433;Initial Catalog=HoLTestDB;Persist Security Info=True;
User ID = xx@ydxpy7fu4v Password = yyyyyy  ;Trusted_Connection=False;Encrypt=True;" providerName="System.Data.SqlClient" />


    d.Create Service Package Only
    e. Create a new host and upload the published package.
3. Test Results
   

沒有留言:

張貼留言