Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

SQL Server Developer Edition on Amazon Linux 2023 AMI

0

Trying to get a Developer Edition SQL Server 2019 running on Amazon Linux 2023 AMI

  1. Cannot seem to find the minimum instance type support by this edition. Microsoft indicates min 1Gb RAM recommended 4GB. So I tried t2.medium
  2. Instance launches fine so proceed to install SQL Server using https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-red-hat?view=sql-server-ver15&tabs=rhel8&source=docs
  3. sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/8/mssql-server-2019.repo
  4. sudo yum install -y mssql-server
  5. sudo /opt/mssql/bin/mssql-conf setup
  6. Selected Edition 2 (Developer). All went smoothly and response at the end is "Setup has completed successfully. SQL Server is now starting."
  7. Now to verify. systemctl status mssql-server

mssql-server.service: Scheduled restart job, restart counter Stopped mssql-server.service - Microsoft SQL Server Database mssql-server.service: Start request repeated too quickly mssql-server.service: Failed with result 'exit-code' Failed to start mssql-server.service - Microsoft SQL Server

  1. sudo ls /var/opt/mssql/log shows no errorlog file.

"Yes, you can run Microsoft SQL Server on AWS Linux, including Amazon Linux," so it seems it should work.

Anyone got this going?

Topics
ComputeDatabase
Tags
Microsoft SQL ServerAmazon Linux
Language
English

asked 2 years ago729 views

2 Answers
0

While it's technically possible to run Microsoft SQL Server on Linux, including Amazon Linux, there are some important considerations and potential issues with the approach you've described:

  1. SQL Server Developer Edition is not officially supported on Amazon Linux 2023. Microsoft's documentation typically refers to Red Hat Enterprise Linux (RHEL) or Ubuntu for Linux installations.

  2. The instance type t2.medium should be sufficient for SQL Server Developer Edition, as it meets the minimum RAM requirements.

  3. The installation steps you followed are for Red Hat Enterprise Linux 8, which may not be fully compatible with Amazon Linux 2023.

  4. The lack of an errorlog file in /var/opt/mssql/log suggests that the SQL Server service is failing to start properly.

To resolve this issue, you have a few options:

  1. Consider using an officially supported Linux distribution for SQL Server, such as RHEL or Ubuntu.

  2. If you must use Amazon Linux, try using Amazon Linux 2 instead of Amazon Linux 2023, as it may have better compatibility with the SQL Server installation process.

  3. Check system requirements and ensure all prerequisites are met for SQL Server on Linux.

  4. Review system logs (e.g., /var/log/messages) for any error messages related to SQL Server startup.

  5. Verify that SELinux or other security measures are not interfering with SQL Server's operation.

If you need to run SQL Server Developer Edition on AWS, a more straightforward approach would be to use Amazon RDS for SQL Server or launch a Windows EC2 instance with SQL Server pre-installed. These options provide better support and compatibility for running SQL Server in the AWS environment.
Sources
Create a SQL Server Developer Edition instance using BYOM on Amazon RDS Custom for SQL Server | AWS Database Blog

answered 2 years ago

0

Hello,

Thank you for your question.

SQL Server Developer Edition Compatibility: We understand your desire to use SQL Server Developer Edition on Amazon Linux 2023. However, as you've noted, this configuration is not officially supported by Microsoft. Their documentation primarily recommends Red Hat Enterprise Linux (RHEL) or Ubuntu for Linux installations.

Instance Type Adequacy: We concur that the t2.medium instance type should be sufficient for SQL Server Developer Edition, as it meets the minimum RAM requirements. Your choice here is appropriate.

Installation Process: We've observed that the installation steps you followed are designed for Red Hat Enterprise Linux 8. This may indeed lead to compatibility issues with Amazon Linux 2023, potentially explaining the difficulties you're experiencing.

Service Start-up Issues: The absence of an errorlog file in /var/opt/mssql/log is concerning and suggests that the SQL Server service is unable to initialize properly.

AWS
SUPPORT ENGINEER

answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content