My Blog

SQL Server 2012 Express on Cloud

1-click AWS Deployment 1-click Google Deployment

Overview

SQL Server 2012 Express edition is the entry-level, free database and is ideal for learning and building desktop and small server data-driven applications. It is the best choice for independent software vendors, developers, and hobbyists building client applications.

If you need more advanced database features, SQL Server Express can be seamlessly upgraded to other higher end versions of SQL Server. New in SQL Server 2012 is SQL Server Express LocalDB, a lightweight version of Express that has all of its programmability features, yet runs in user mode and has a fast, zero-configuration installation and a short list of prerequisites.

Cognosys provides hardened images of SQL Server 2012 Express edition on all public cloud ( AWS marketplace and Google Cloud Platform).

Deploy SQL Server 2012 Express on Cloud securely on cloud i.e. AWS marketplace and Google Cloud Platform (GCP) with Reliable Services offered by Cognosys at one-click with easy written and video tutorials.

Secured SQL Server 2012 SP2 Express on Windows 2012 R2

SQL Server 2012 on cloud for AWS

 

Features

Major Features of SQL SERVER 2012 

1. Cross-Box Scale Limits
2. High Availability
3. Scalability and Performance
4. Security
5. Replication
6. Management Tools
7. RDBMS Manageability
8. Development Tools
9. Programmability

AWS

Installation Instructions For Windows

Installation Instructions for Windows

Step 1) RDP  Connection: To connect to the deployed instance, Please follow Instructions to Connect to Windows  instance on AWS Cloud

Connect to virtual machine using following RDP credentials :

  • Hostname: PublicDNS  / IP of machine
  • Port : 3389

Username: To connect to the operating system, use RDP and the username is Administrator.
Password : Please Click here  to know how to  get password .

Step 2) SQL Connection: To Connect Microsoft SQL Server Management Studio in windows server, Please follow Instructions to Connect Microsoft SQL Server Management Studio

Step 3) Database Credentials:

You can Login by below SQL Database credentials

      SQL UserName : sa ||  Password : Passw@rd123

Note: You can reset ‘sa’ password by using windows authentication to connect to local SQL instance. Please use localhost in the server name when connecting from inside the RDC

Step 4) Other Information:

1.Default ports:

  • Windows Machines:  RDP Port – 3389
  • sql server port :1433: By default, this is blocked on Public interface for security reasons.

Configure custom inbound and outbound rules using this link

Installation Step by Step Screenshots

Google

Installation Instructions For Windows

Installation Instructions for Windows

Step 1) VM Creation:

  1. Click the Launch on Compute Engine button to choose the hardware and network settings.

2.You can see at this page, overview of Cognosys Image as well as some estimated costs of VM.

3.In the settings page, you can choose the number of CPUs and amount of RAM, the disk size and type etc.

Step 2) RDP Connection: To connect to the deployed instance, Please follow Instructions to Connect to Windows instance on Google Cloud

Step 3) SQL Connection: To Connect Microsoft SQL Server Management Studio in Windows Server, Please follow Instructions to Connect Microsoft SQL Server Management Studio

Step 4) Database Credentials:

You can Login by below SQL Database credentials

   SQL UserName : sa

Step 1. For getting password , Please follow below.

Step 2:  SQL sa Password details.

Step 3: Click on Custom Metadata for sa Password details.

Step 4: Connect to SQL Management Studio Using the credentials as provided in Custom Metadata above.Please change password at earliest.

Step 5 ) Other Information:

1.Default ports:

  • Windows Machines:  RDP Port – 3389
  • sql server port :1433: By default, this is blocked on Public interface for security reasons.

Videos

Secured SQL Server 2012 SP2 Express on Windows 2012 R2

Introduction to MS SQL Server 2012 Administration

SQL Server 2012 Express on Cloud

Related Posts