SQL Server 2019 Standard on Windows 2019

This product has charges associated with it for seller support. SQL Server 2019 Standard on Windows 2019 offers a powerful, scalable, and secure database platform tailored to the demands of modern applications. Featuring advanced capabilities like intelligent query processing, in-memory databases, and cross-platform support for Windows, this AMI allows developers and organizations to efficiently handle data workloads while boosting performance. It also includes features for high availability, disaster recovery, and built-in security, making it ideal for mission-critical applications. Key use cases include data warehousing, business intelligence, and application development. Easily deploy and scale your SQL Server environments in the AWS EC2 cloud, ensuring both flexibility and cost-effectiveness, while maintaining the reliability expected from the SQL Server ecosystem.

0 AWS reviews

View purchase options

Overview

This is a repackaged open-source software product wherein additional charges apply for support.

Quickly and efficiently deploy SQL Server 2019 Standard on Windows Server 2019 in the AWS cloud. This robust AMI offers enterprise-grade performance, scalability, and advanced database management capabilities tailored to modern business needs.

Features

Comprehensive Database Management: Boost performance with in-memory technology, data virtualization, and integrated analytics for dynamic workloads.
High Availability and Disaster Recovery: Ensure resilience with enhanced Always On availability groups, minimizing downtime and protecting your data.
Versatile Data Compatibility: Manage structured, semi-structured, and unstructured data to meet diverse business and application requirements.
Enhanced Security Features: Safeguard sensitive information with built-in security measures like Transparent Data Encryption (TDE) and Always Encrypted.

Benefits

Cost-Efficiency: Utilize pay-as-you-go pricing to optimize operational costs and scale resources as needed.
Flexibility and Scalability: Seamlessly grow your database infrastructure alongside your business without heavy hardware investments.
Familiar Environment: Easily integrate with Microsoft tools and technologies, streamlining workflows and reducing the learning curve for teams.

Use Cases

Enterprise Applications: Deliver reliable performance for mission-critical business applications requiring a robust relational database.
Business Intelligence and Analytics: Leverage advanced analytics and reporting tools to unlock actionable insights from your data.
Development and Testing: Set up isolated SQL Server environments quickly, empowering development teams to innovate without impacting production systems.

Transform your database management experience with SQL Server 2019 Standard on AWS. Launch today and unlock the full potential of your cloud-based relational databases!

Try our other popular images

Why Choose Gigabits?
With over a decade of experience in AWS and other cloud platforms, Gigabits offers open-source software packaged into scalable cloud solutions that you can deploy on demand.

Highlights

SQL Server 2019 Standard on Windows 2019 offers strong performance and advanced capabilities tailored for modern applications. This AMI includes high availability and disaster recovery options to keep your data secure and accessible. With features such as Intelligent Query Processing and memory-optimized tempdb, it boosts operational efficiency, making it well-suited for data-intensive workloads and enterprise-grade database applications.
Harness the scalability of SQL Server 2019 Standard to support a wide range of workloads. Its integration with Azure facilitates seamless hybrid cloud solutions, enabling businesses to expand their database capabilities while maintaining agility. This AMI is ideal for organizations seeking flexible deployment options for business intelligence, data warehousing, and operational analytics, ensuring that diverse business needs are met.
Deploying SQL Server 2019 Standard on Windows 2019 provides advanced security features like Always Encrypted and dynamic data masking to ensure critical data protection. The built-in machine learning capabilities enable organizations to extract valuable insights directly from their data. With comprehensive tools and strong support for DevOps practices, this AMI is ideal for teams looking to innovate and accelerate application delivery, all within a secure environment.

Details

Sold by

Gigabits

Typical total price

This estimate is based on use of the seller's recommended configuration (t2.large) in the US East (N. Virginia) Region. View pricing details

$0.281/hour

Features and programs

Financing for AWS Marketplace purchases

AWS Marketplace now accepts line of credit payments through the PNC Vendor Finance program. This program is available to select AWS customers in the US, excluding NV, NC, ND, TN, & VT.

View financing details

Pricing

SQL Server 2019 Standard on Windows 2019

Info

View purchase options

Pricing is based on actual usage, with charges varying according to how much you consume. Subscriptions have no end date and may be canceled any time. Alternatively, you can pay upfront for a contract, which typically covering your anticipated usage for the contract duration. Any usage beyond contract will incur additional usage-based costs.

Additional AWS infrastructure costs may apply. Use the AWS Pricing Calculator to estimate your infrastructure costs.

Region

Usage costs (276)

Info

Instance type	Product cost/hour	EC2 cost/hour	Total/hour
t1.micro	$0.06	$0.02	$0.08
t2.nano	$0.06	$0.008	$0.068
t2.micro AWS Free Tier	$0.20	$0.016	$0.216
t2.small	$0.90	$0.032	$0.932
t2.medium	$0.14	$0.064	$0.204
t2.large Recommended	$0.16	$0.121	$0.281
t2.xlarge	$0.28	$0.227	$0.507
t2.2xlarge	$0.55	$0.433	$0.983
t3.nano	$0.07	$0.01	$0.08
t3.micro AWS Free Tier	$0.10	$0.02	$0.12

Additional AWS infrastructure costs

Type	Cost
EBS General Purpose SSD (gp2) volumes	$0.10/per GB/month of provisioned storage

Vendor refund policy

The instance can be terminated at anytime to stop incurring charges. No refund available.

How can we make this page better?

We'd like to hear your feedback and ideas on how to improve this page.

Legal

Vendor terms and conditions

Upon subscribing to this product, you must acknowledge and agree to the terms and conditions outlined in the vendor's End User License Agreement (EULA) .

Content disclaimer

Vendors are responsible for their product descriptions and other product content. AWS does not warrant that vendors' product descriptions or other product content are accurate, complete, reliable, current, or error-free.

Usage information

Info

Delivery details

64-bit (x86) Amazon Machine Image (AMI)

Amazon Machine Image (AMI)

An AMI is a virtual image that provides the information required to launch an instance. Amazon EC2 (Elastic Compute Cloud) instances are virtual servers on which you can run your applications and workloads, offering varying combinations of CPU, memory, storage, and networking resources. You can launch as many instances from as many different AMIs as you need.

Version release notes

first release

Additional details

Usage instructions

Below is a step-by-step process on using SQL Server with Windows on AWS.

1. Getting Started with Windows on AWS

You can learn more about Windows usage on AWS through this AWS Windows page . This page contains resources on deploying Windows-based EC2 instances, licensing options, and using Microsoft services on AWS.

2. Logging in as Administrator

To log in to your AWS Windows instance as an Administrator, follow these steps:

Go to the AWS Support Knowledge Center to retrieve the Administrator password.
Use the private key (.pem) file you generated when you created your EC2 instance to decrypt the Administrator password.
After obtaining the password, you can use it to log in to your Windows instance through Remote Desktop (RDP).

3. SQL Server and sa Account

By default, the sa (System Administrator) account in SQL Server is disabled for security reasons. You can log in using the local Windows Administrator account to manage SQL Server:

Open SQL Server Management Studio (SSMS) from the Start Menu:
- Navigate to Microsoft SQL Server Tools 18 Microsoft SQL Server Management Studio.
In SSMS, log in with the Windows Authentication method using the local Windows Administrator credentials.
To enable the sa account:
- In SQL Server Management Studio, go to Object Explorer --> expand your SQL Server instance --> Security --> Logins.
- Right-click on the sa account --> Properties.
- On the General tab, uncheck the Disabled box, and set a strong password.
Alternatively, you can create a new SQL Server login:
- Right-click on Logins --> New Login.
- Specify a username, password, and authentication method.

4. Launch SQL Server Management Studio (SSMS)

To open SSMS, go to the Start Menu and search for Microsoft SQL Server Tools 18 --> Microsoft SQL Server Management Studio.
Once opened, you can connect to your SQL Server instance using either Windows Authentication or SQL Server Authentication

Support

Vendor support

For support and any issues related to all our images, please contact support@gigabitscloud.com , Do not hesitate to contact us in case you observe any issues on the image or request a new update that's not available yet.

AWS infrastructure support

AWS Support is a one-on-one, fast-response support channel that is staffed 24x7x365 with experienced and technical support engineers. The service helps customers of all sizes and technical abilities to successfully utilize the products and features provided by Amazon Web Services.

Get support

Similar products

Microsoft SQL Server 2019 Standard on Windows Server 2019

By Amazon Web Services

SQL Server on AWS has lower TCO, higher performance, and the broadest and deepest capabilities. This SQL Server Amazon Machine Images (AMI) is built by Amazon Web Services (AWS) for use on Amazon EC2, the proven, reliable, and secure place for SQL Server.

View product