Posts tagged adventureworks

Notes on setting up the sample database – adventureworks [click here] for Microsoft’s cloud computing sql server called Azure:

• you need an account – get one from sql.azure.com - it takes some time for your access information to arrive by email.
• download the sample database using link above
• extract/unzip to a known location
• make sure you add your home/work/workstation actual external facing ip address to the firewall settings
• wait for 5-10 mins for your ip address to be accepted by the azure online firewall system
• run the script commands below

See commands/reference pictures below:

Server Name:        serverx        serverx.database.windows.net
Administrator Username:     userx
Server Location:     South Central US
db name: ankh

cd dw
buildawdwaz.cmd tcp:serverx.database.windows.net userx@serverx passwordx

cd lt
buildawltaz.cmd tcp:serverx.database.windows.net userx@serverx passwordx