Windows Azure Pack vs. VMware VRA (vi) Azure pack MSSQL PAAs functional test

platform as a service (platform as aservices, abbreviated as PaaS) is a cloud computing service that provides the computing platform and the solution stack as a service. At the typical level of cloud computing, the platform-as-a-service layer is between software-as-a-service and infrastructure-as-a-service.

Platform-as-a-service provides users with the ability to deploy and create cloud infrastructures to clients, or gain access to programming languages, libraries, and services. Users do not need to manage and control the cloud infrastructure, including networks, servers, operating systems, or storage, but need to control the upper-level application deployment and application-hosted environment.

PAAs serves as a service for software-developed platforms, delivering software-as-a-service (SaaS) models to users. Therefore, PAAs is also an application of the SaaS model. However, the advent of PAAs can accelerate the development of SaaS, especially to speed up the development of SaaS applications.

Platform as a service (PaaS) This is a new software application pattern or architecture that arises after software as a service (software as a services, or SaaS). Is the further development of the application service provider (the application service Provider, or ASP).

In this experiment, the MS SQL PAAs service test was performed and the database was successfully installed on another server.

1. Manage Portal Connection data.

First Use Administrator login Azurepack Manage address: https://azurepack01.yueque.com:30091/, click "SQL Server", click "Add".

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/8f/27/wkiom1ju32cy1zraaadab_hhy3e107.png "height=" 396 "/>

Enter the FQDN of the database, user name, password, database size.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/8f/27/wkiom1ju32gschwraadugqei3gs016.png "height=" 452 "/>

Wait for the connection to be created successfully.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/8f/25/wkiol1ju32lj0ewoaadaezwggee615.png "height=" 395 "/>

2. Create a user plan.

Create a schedule. Click "Create".

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/8f/27/wkiom1ju32oblsjhaacugqytzai814.png "height=" 345 "/>

Click Create Schedule

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/8f/27/wkiom1ju32sd-fqgaabuz_znhde030.png "height=" 281 "/>

Enter the name of the plan

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/8f/25/wkiol1ju32wgxrjdaabeyribmrm803.png "height=" 427 "/>

Select "SQL Server"

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/8f/25/wkiol1ju32wyp3_qaacyaowf7ey850.png "height=" 430 "/>

Wait for the plan to be created successfully.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/8f/27/wkiom1ju32fxdfrxaada_wrtqfi875.png "height=" 351 "/>

Click "Plan for MS SQL" and select "Publish".

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/8f/25/wkiol1ju32nbk_jdaadmzt1pnxu262.png "height=" 358 "/>

The plan was published successfully.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/8f/27/wkiom1ju32rjfi7yaac-tzkng_q939.png "height=" 361 "/>

3. Create a user and associated database plan.

Select a created user and click the user.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/8f/25/wkiol1ju32uhl229aac-zey_gf4679.png "height=" 362 "/>

Click Add "Subscribe"

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/8f/27/wkiom1ju32yqgkleaacuqpc526q888.png "height=" 361 "/>

Wait for the subscription to finish adding.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/8f/27/wkiom1ju322irlehaacpcnejxns594.png "height=" 364 "/>

4. User Login and database creation test

Open IE Browser, enter https://azurepack01.yueque.com:30081, use [email protected] user to login

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/8f/25/wkiol1ju33dyfnnaaajxs9bzewo019.png "height=" 432 "/>

In the database column, select Create New data.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/8f/25/wkiol1ju33gbprwsaac7a5x2gu4916.png "height=" 444 "/>

Enter the name of the database

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/8f/25/wkiol1ju33hjotn9aabi9ph8ux4253.png "height=" 470 "/>

Enter database user name, password information

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/8f/25/wkiol1ju33ld0ih8aacnpmhcoli769.png "height=" 473 "/>

Wait for database creation to complete.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/8f/27/wkiom1ju33bt9zx3aacqnusxecm175.png "height=" 413 "/>

Use the SQL Connection management tool to connect to the database.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/8f/25/wkiol1ju33eqozltaafmlqegngi287.png "height=" 494 "/>

The login was successful and the database connection was successful.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/8f/27/wkiom1ju33fdgdd1aacbimehujs272.png "height=" 179 "/>

The user accesses another user's database and clicks open Error.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/8f/25/wkiol1ju33jzxzocaablcvrbokk900.png "height=" 138 "/>

CREATE table succeeded.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/8f/25/wkiol1ju33mxd-zlaaeyxuksbha075.png "height=" 381 "/>

At this point, the MS SQL DB PAAs creation test was successful.

This article is from the "Month Missing" blog, please be sure to keep this source http://yueque.blog.51cto.com/4580340/1910095

Windows Azure Pack vs. VMware VRA (vi) Azure pack MSSQL PAAs functional test