Issues deploying MSSQL to Render

1

I’ve been trying to deploy MSSQL onto Render using the following example:

Unfortunately it consistently fails with exit code 126 and the following logs:

Jun 4 09:57:18 AM  Starting service...
Jun 4 09:57:21 AM  SQL Server 2022 will run as non-root by default.
Jun 4 09:57:21 AM  This container is running as user mssql.
Jun 4 09:57:21 AM  To learn more visit https://go.microsoft.com/fwlink/?linkid=2099216.
Jun 4 09:57:21 AM  /opt/mssql/bin/permissions_check.sh: line 60: /opt/mssql/bin/sqlservr: Operation not permitted
Jun 4 09:57:21 AM  /opt/mssql/bin/permissions_check.sh: line 60: /opt/mssql/bin/sqlservr: Success
Jun 4 09:57:22 AM  SQL Server 2022 will run as non-root by default.
Jun 4 09:57:22 AM  This container is running as user mssql.
Jun 4 09:57:22 AM  To learn more visit https://go.microsoft.com/fwlink/?linkid=2099216.
Jun 4 09:57:22 AM  /opt/mssql/bin/permissions_check.sh: line 60: /opt/mssql/bin/sqlservr: Operation not permitted
Jun 4 09:57:22 AM  /opt/mssql/bin/permissions_check.sh: line 60: /opt/mssql/bin/sqlservr: Success

Looking into the MSSQL/Docker issue tracker, I found the following bug tracking Linux capabilities:

Potentially related:

Is anyone aware of a workaround or a way to set capabilities on Render?

2

Hello Jonah,

I’m sorry, but on Render, you cannot bind to privileged ports (i.e. ports below 1024). As per the issue you linked MSSQL is trying to bind to port 135 which isn’t possible.

Regards,
Keith

3

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.