Blending life, nature and technology.
Azure sample database setup….
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
| Print article | This entry was posted by steve on December 29, 2009 at 11:57 am, and is filed under Software, computers, microsoft, programming, sql server, visual Studio .Net, websites, windows, windows server 2008. Follow any responses to this post through RSS 2.0. You can leave a response or trackback from your own site. |
No comments yet.
No trackbacks yet.
MCITP Exam 70-450
about 2 months ago - No comments
Microsoft Exam 70-450: PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008 Passed this exam on 5/25. It rained heavily all day. Books for this exam arent really out yet, even from Microsoft. Theres a new book that came out l’ll immediately recommend to anyone – its very concise, real-world
SQL Server 2008 Data Collection..
about 3 months ago - No comments
“SQL Server 2008 provides a data collector that you can use to obtain and save data that is gathered from several sources. The data collector enables you to use data collection containers, which enable you to determine the scope and frequency of data collection on a computer that is running SQL Server 2008.” Setup steps
SQL Server 2008 R2 installation notes…
about 3 months ago - No comments
Click here to view my installation by pictures webpage for Microsoft SQL Server 2008 R2
Installing Sharepoint 2010 Beta..
about 5 months ago - No comments
Microsoft Sharepoint 2010 beta software requires the following: Application server role, web server IIS Role SQL Server 2008 native client Microsoft “Geneva” framework runtime Microsoft Chart Controls for Microsoft Framework 3.5 Microsoft Filter Pack 2.0 SQL Server 2008 Analysis Services ADOCMD.NET I attempted to install this on a development Windows 2008 R2 server, which already
Transferring logins and passwords between SQL Server 2005 and SQL Server 2008
about 6 months ago - No comments
This link is very useful and details how to transfer the logins and the passwords between instances of Microsoft SQL Server 2005, and Microsoft SQL Server 2008, on different servers. – Microsoft Knowledge Base: #246133
Microsoft SQL Server, Error: 15401
about 6 months ago - No comments
Got this error a lot when trying to add NT user accounts on a SQL Server 2008 installation that was connected to a Windows 2008R2 server running Active Directory 2008 at Windows 2000 functional level. Same error message appeared when troubleshooting this from a SQL Server 2005 instance in the same server environment. You’ll keep
Business Intelligence w/SQL 2008
about 7 months ago - No comments
Currently reading “Delivering Business Intelligence with Microsoft SQL Server 2008 by Brian Larson” Interesting quotes/definitions: “Would you tell me please, which way I ought to go from here?” asked Alice. “That depends a good deal on where you want to get to,” said the Cat. “I don’t much care where,” said Alice. “Then, it doesn’t matter
Azure SQL….
about 7 months ago - No comments
Adventure works sample databases are now available for Microsoft’s SQL Azure at codeplex – click here.
SQL Azure
about 7 months ago - No comments
SQL Azure is a fully relational database in the cloud by Microsoft. See this link for the main website. For how to connect to Azure using ADO.Net heres a good link from msdn and another link which l’m currently using to work on plugging the northwind sample database to azure and using a WPF datagrid
collection_set_3_upload job keeps failing on uploading Query Statistics – SQL Server 2008
about 9 months ago - No comments
Keep getting the error messages below from the logs: To view the detailed logs in SSMS 2008: Drill down on Management -> data collection -> query statistics -> view logs ====== Error Messages Below===== Event Data Code Message SSIS error. Component name: DFT – Upload collection snapshot, Code: -1073450974, Subcomponent: SSIS.Pipeline, Description: SSIS Error Code