SQL Server Sp2 Express with IIS on Cloud

1-click AWS Deployment 1-click Google Deployment

Overview

SQL Server SP2 Express  edition with IIS delivers basic data management and business intelligence database for departments and small organizations to run their applications and supports common development tools for on-premise and cloud — enabling effective database management with minimal IT resources.

Core data management and business intelligence capabilities with minimal IT resources.

Internet Information Services (IIS, formerly Internet Information Server) is an extensible web server created by Microsoft for use with Windows NT family.IIS supports HTTP, HTTPS, FTP, FTPS, SMTP and NNTP. It has been an integral part of the Windows NT family since Windows NT 4.0, though it may be absent from some editions (e.g. Windows XP Home edition) and is not active by default.

Internet Information Services (IIS, formerly Internet Information Server) on Cloud runs on Amazon Web Services (AWS) and Google Cloud Platform (GCP) and is built to provides a secure, easy-to-manage, modular and extensible platform to test websites and visual means of creating, configuring, and publishing sites on the web.

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

Deploy SQL Server SP2 Express  edition with IIS  securely on cloud i.e. AWS marketplaceAzure and Google Cloud Platform (GCP)

Features

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

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

Google

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 Google Cloud

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

Videos

Introduction To Microsoft SQL Server

SQL Server Sp2 Express with IIS on Cloud

Related Posts