My Blog

SQL Server Standard 2014 on cloud

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

Overview

SQL Server Standard 2014 is designed for serving as a back end for internal applications, or even powering a dynamic website. It offers basic subset of database, reporting and analytic capabilities.

Standard edition of SQL server 2014 provides basic availability and disaster recovery with up to two node fail-over clustering, log shipping and peer-to-peer replication. As basic availability and disaster recovery with two node failover clustering, log shipping and peer-to-peer replication.

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

Deploy Standard edition of SQL server 2014 securely on cloud i.e. AWS marketplaceAzure and Google Cloud Platform (GCP)

We also provide the different edition’s of SQL Server 2014 such as SQL Server 2014 Web Edition, SQL Server 2014 Express and SQL Server Enterprise 2014.

SQL Server 2014 SP2 Standard Edition on Windows 2012 R2

SQL Server Standard 2014 on cloud for AWS

Features

Major Features of SQL Server Standard 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 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: 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

Note: Please change the password after the first login.

Step 4) Other Information:

1.Default ports:

  • Windows Machines:  RDP Port – 3389
  • Http: 80
  • Https: 443
  • SQL Server Port: 1433 this is by default not allowed on the firewall for security.

Configure custom inbound and outbound rules using this link

Installation Step by Step Screenshots

b

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, an overview of Cognosys Image as well as estimated cost of running the instance.

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 initialize local DB server 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

The below screen appears after successful deployment of the image.

i) Please connect to Remote Desktop as given in step 2
ii) You can use SQL server instance as localhost. The SQL Server instance name to be used is “localhost” Connect to SQL Management Studio with username as sa and password provided in Custom Metadata.

If you have closed the deployment page you can also get the sa password from VM Details “Custom metadata” Section.

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

SQL Server 2014 SP2 Standard Edition on Windows 2012 R2

SQL Server Standard 2014 on cloud

Related Posts