SQL Server 2008 Standard Edition on Cloud

1-click AWS Deployment 1-click Azure Deployment

Overview

SQL Server 2008 Standard Edition provides the relational database capabilities you would expect, as well as basic BI and reporting features. Its notable omissions include PowerPivot, Power View, Master Data Services, advanced auditing, transparent data encryption, columnstore indexes, and other data warehousing features.

SQL Server 2008 Standard Edition also includes support for two-node AlwaysOn failover clusters. Microsoft will also continue to offer the free SQL Server 2008 Express Edition, which includes the new LocalDB feature for lightweight deployments.

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

Deploy SQL Server 2008 Standard Edition  securely on cloud i.e. AWS marketplaceAzure and Google Cloud Platform (GCP)

SQL Server 2008 Standard Edition on Cloud for AWS

Features

Major Features of SQL Server 2008 Standard Edition

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

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 change the password after the first login.

Step 4) Other Information:

1.Default installation path:  “C:\Program Files (x86)\Microsoft SQL Server”

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

 

Videos

 

SQL Server 2008 Standard Edition on Cloud

Related Posts