SQL Server 2016 SP1 Express on cloud

 

1-click AWS Deployment 1-click Google Deployment

Overview

SQL Server 2016 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.

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.

SQL Server 2016 Express edition is ideal for deploying small databases in production environments and makes leading innovation available to any public cloud like SQL Server 2016 Express edition on AWS marketplace  and Google Cloud ( GCP ).

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

Deploy SQL Server 2016 Express edition  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.

Features

Major Features of SQL Server 2016 Express Edition

  • Core: Maximum number of cores is 4.
  • Memory: Maximum buffer pool size per instance is 1410 MB
  • Memory: Maximum Column store segment cache per instance is 352 MB
  • DB Size: Maximum database size is 10 GB
  • Advanced Security: Always Encrypted, row-level security, data masking, fine-grained auditing

AWS

Installation Instructions for Windows

Note: How to find PublicDNS in AWS

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

1) Connect to the 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: Please use localhost in the server name when connecting from inside the RDC

Note: Please change the password after the first login.

Step 4) Other Information:

1.Default installation path:  “C:\Program Files\Microsoft SQL Server 2016”

2.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

Google

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: Click on Custom Metadata for sa Password details.

Step 3: 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 installation path:  “C:\Program Files\Microsoft SQL Server 2016”
2.Default ports:

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

Videos

Introduction To Microsoft SQL Server 2016

SQL Server 2016 SP1 Express on cloud

Related Posts