Creating an SQL Azure Database in Word

Drawing QR Code 2d barcode in Word Creating an SQL Azure Database

Creating an SQL Azure Database
Generating QR Code In None
Using Barcode generator for Word Control to generate, create Denso QR Bar Code image in Office Word applications.
www.OnBarcode.com
Barcode Encoder In None
Using Barcode encoder for Office Word Control to generate, create Barcode image in Microsoft Word applications.
www.OnBarcode.com
You will be creating a database in SQL Azure in order perform create, read, update, and delete operations for the Notepad application.
PDF 417 Creation In None
Using Barcode creation for Office Word Control to generate, create PDF417 image in Office Word applications.
www.OnBarcode.com
Printing Barcode In None
Using Barcode maker for Microsoft Word Control to generate, create Barcode image in Office Word applications.
www.OnBarcode.com
Signing Up for SQL Azure
Encode European Article Number 13 In None
Using Barcode generator for Word Control to generate, create European Article Number 13 image in Office Word applications.
www.OnBarcode.com
Generate QR Code In None
Using Barcode generator for Microsoft Word Control to generate, create QR Code ISO/IEC18004 image in Word applications.
www.OnBarcode.com
You will learn to create an SQL Azure account in the following steps. 1. 2. Open a browser of your choice. Go to www.microsoft.com/windowsazure/ to sign up and buy the Windows Azure service account. Follow the direction provided by Microsoft in order to purchase and acquire the service account in order to continue with the following steps. You can use Microsoft Azure each month for free (25 hours of computing time, 500 MB storage, 10,000 storage transactions, 1 GB database, and 500 MB data transfer); this promotional offer might end soon, though. Go to http://sql.azure.com/ and sign in using the account you created in Step 1. Once signed in, click the SQL Azure menu tab on the left side. When the Windows Azure page loads, you will see the project that you created during the registration process in Step 1. See Figure 3 4, which corresponds to this step.
Code128 Maker In None
Using Barcode generation for Word Control to generate, create ANSI/AIM Code 128 image in Microsoft Word applications.
www.OnBarcode.com
Intelligent Mail Generator In None
Using Barcode maker for Office Word Control to generate, create Intelligent Mail image in Microsoft Word applications.
www.OnBarcode.com
3. 4.
QR Code 2d Barcode Drawer In Java
Using Barcode generation for Java Control to generate, create QR Code 2d barcode image in Java applications.
www.OnBarcode.com
QR Code ISO/IEC18004 Maker In Java
Using Barcode drawer for Eclipse BIRT Control to generate, create Denso QR Bar Code image in BIRT applications.
www.OnBarcode.com
CHAPTER 3 USING CLOUD SERVICES AS DATA STORES
ANSI/AIM Code 128 Encoder In Visual Basic .NET
Using Barcode encoder for .NET framework Control to generate, create Code-128 image in .NET framework applications.
www.OnBarcode.com
Create Denso QR Bar Code In Visual Basic .NET
Using Barcode creation for Visual Studio .NET Control to generate, create QR Code JIS X 0510 image in VS .NET applications.
www.OnBarcode.com
Figure 3 4. SQL Azure main screen
Make Barcode In None
Using Barcode drawer for Online Control to generate, create Barcode image in Online applications.
www.OnBarcode.com
EAN 128 Drawer In Objective-C
Using Barcode drawer for iPad Control to generate, create GS1-128 image in iPad applications.
www.OnBarcode.com
Connecting to the SQL Azure Project
Data Matrix 2d Barcode Creator In Java
Using Barcode generator for Java Control to generate, create Data Matrix image in Java applications.
www.OnBarcode.com
Matrix Barcode Encoder In VB.NET
Using Barcode maker for Visual Studio .NET Control to generate, create 2D image in VS .NET applications.
www.OnBarcode.com
After you register and purchase your Azure service account, you can now log in to an SQL Azure portal. 1. Click the project hyperlink NAS-DEV. In your case, you should click the name of the project that corresponds to the one you created in the Signing up for SQL Azure section. Click the I Accept button on the Terms of Use page, as shown in Figure 3 5.
Encoding Code 3 Of 9 In VS .NET
Using Barcode generator for ASP.NET Control to generate, create Code 3 of 9 image in ASP.NET applications.
www.OnBarcode.com
Paint 1D Barcode In VS .NET
Using Barcode creator for Visual Studio .NET Control to generate, create Linear image in VS .NET applications.
www.OnBarcode.com
CHAPTER 3 USING CLOUD SERVICES AS DATA STORES
Painting EAN / UCC - 13 In VB.NET
Using Barcode generator for .NET framework Control to generate, create EAN 13 image in VS .NET applications.
www.OnBarcode.com
Generate ECC200 In .NET
Using Barcode printer for Reporting Service Control to generate, create Data Matrix 2d barcode image in Reporting Service applications.
www.OnBarcode.com
Figure 3 5. SQL Azure Terms of Use screen
Creating an SQL Azure Database
Here you will be creating an SQL Azure database with a username and password. 1. On the Create Server page, enter NotepadAdmin as the administrator username and P@ssword as the administrator password. Retype the password, and choose North Central US on the Location drop-down. See Figure 3 6 for the inputs. Note that for the location, you would want to choose the region where you are closest for optimal performance. If you are planning to deploy the application to a specific region, then you would want to select the appropriate region here.
CHAPTER 3 USING CLOUD SERVICES AS DATA STORES
Figure 3 6. SQL Azure Create Server screen 2. Click the Create Server button and you will see Figure 3 7. Take note of the server name assigned to your SQL Azure database as you will need this information to connect using SQL Server Management Studio in Step 20.
CHAPTER 3 USING CLOUD SERVICES AS DATA STORES
Figure 3 7. SQL Azure Server Administration screen 3. Click Create Database. When the pop-up window appears, enter NotepadDB as the name of your database, choose Web on the Specify an edition dropdown menu, and choose 1GB on the Specify the max size drop-down menu, as shown in Figure 3 8. Now click the Create button.
CHAPTER 3 USING CLOUD SERVICES AS DATA STORES
Figure 3 8. SQL Azure create database screen
Configuring the SQL Azure Firewall
In the next steps, you will learn to properly configure the SQL Azure firewall so you can connect to the database. By default SQL Azure denies all access to the database until you add specific IP. 1. Notice that NotepadDB now appears in the list of databases on the Databases tab. Now click the Firewall Settings tab, where you will add your IP to the firewall in order to access the SQL Azure database that you just created from the Microsoft SQL Management Console application to perform various databaserelated tasks.
CHAPTER 3 USING CLOUD SERVICES AS DATA STORES
Select Allow Microsoft Services to access to this server check box, which will allow programs like Microsoft SQL Management consoles to connect directly to the SQL Azure database, as shown in Figure 3 9.
Figure 3 9. SQL AzureFirewall Settings 3. Click the Add Rule button, and when the popup appears, enter MyComputer into the Name text box. Notice that the popup displays your IP address, which you should now copy and paste into the IP Range text boxes, as shown in Figure 3 10.
Copyright © OnBarcode.com . All rights reserved.