My Blog

SQL Server 2014 Express on cloud

1-click AWS Deployment 1-click Azure Deployment 1-click Google Deployment

Overview

SQL Server Express 2014 is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications. The Express edition is free and ideal for learning, developing, powering desktop, web & small server applications. The SQL Server 2014 Express release includes the full version of SQL Server 2014 Management Studio.

Cognosys Provides Hardened images of SQL Server Express 2014  on the cloud ( AWS marketplace, Azure and Google Cloud Platform).

Deploy SQL Server Express 2014  securely on cloud i.e. AWS marketplaceAzure and Google Cloud Platform (GCP)

Default password for sa is set as Passw@rd123 for SQL Server.
Please change the password after first login.

Secured SQL Server 2014 Express Full IIS on Windows 2012 R2

Sql Server 2014 Express on cloud for AWS

Features

Major Features of SQL Server Express 2014

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

1) 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

Please change the password after the first login.

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. Please change password at earliest.

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

Step 3: Connect to SQL Management Studio Using the credentials as provided in Custom Metadata above.For getting password , Please follow below.

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 2014 Express Full IIS on Windows 2012 R2

SQL Server 2014 Express on cloud

Related Posts