`ubuntu-latest` causes`sqlcmd` not found error with no workflow changes

[matte]

⚠ Public service announcement:
runs-on: ubuntu-22.04 fixes bug below caused by ubuntu-24 upstream docker image failing

Checking if anyone else started have and SQL Server install issue this morning. This may likely be upstream in the docker image, but I do not see change there either: https://github.com/Microsoft/mssql-docker/issues

      - name: Install SQL Server
        uses: Particular/install-sql-server-action@v1.2.0

Starting SQL Server in a Docker container...
Unable to find image 'mcr.microsoft.com/mssql/server:2022-latest' locally
2022-latest: Pulling from mssql/server
3d29464607d8: Pulling fs layer
3374dd749958: Pulling fs layer
18952140cc7b: Pulling fs layer
3d29464607d8: Verifying Checksum
3d29464607d8: Download complete
18952140cc7b: Verifying Checksum
18952140cc7b: Download complete
3d29464607d8: Pull complete
3374dd749958: Verifying Checksum
3374dd749958: Download complete
3374dd749958: Pull complete
18952140cc7b: Pull complete
Digest: sha256:45a1a9d13ca5574cf8e0fe4ae73ab77248b66d9c3132ac9658fb6c16dd72a8af
Status: Downloaded newer image for mcr.microsoft.com/mssql/server:2022-latest
84c256e6e7917907b4f8e0ffb0c91394d046e5e51aa418b8e74c8ad6762e6d43
Setting environment variable SQL_SERVER_CONNECTION_STRING to SQL connection string...
Run # Wait for availability then create initial catalog
  # Wait for availability then create initial catalog
  
  for ($i = 1; $i -le 30; $i++) {
    Write-Output "Attempt $i/30 to connect to SQL Server..."
    sqlcmd -b -Q "SELECT @@SERVERNAME as ServerName" 2>&1>$null
    if ($?) {
      Write-Output "  - SQL Server is now ready"
      break
    } else {
      Write-Output "  - Not ready, sleeping for 5s"
      Start-Sleep -seconds 5
    }
  }
  
  Write-Output "Creating initial catalog 'nservicebus'"
  sqlcmd -Q "CREATE DATABASE [nservicebus]"
  shell: /usr/bin/pwsh -command ". '{0}'"
  env:
    pythonLocation: /opt/hostedtoolcache/Python/3.11.8/x64
    PKG_CONFIG_PATH: /opt/hostedtoolcache/Python/3.11.8/x64/lib/pkgconfig
    Python_ROOT_DIR: /opt/hostedtoolcache/Python/3.11.8/x64
    Python2_ROOT_DIR: /opt/hostedtoolcache/Python/3.11.8/x64
    Python3_ROOT_DIR: /opt/hostedtoolcache/Python/3.11.8/x64
    LD_LIBRARY_PATH: /opt/hostedtoolcache/Python/3.11.8/x64/lib
    SQLCMDPASSWORD: ***
    SQLCMDUSER: sa
    SQLCMDSERVER: localhost,1433
    SQL_SERVER_CONNECTION_STRING: Server=localhost;Database=nservicebus;User Id=sa;***;Encrypt=false;
Attempt 1/30 to connect to SQL Server...
sqlcmd: /home/runner/work/_temp/9a369528-1574-4a96-88ae-a546d866c84a.ps1:6
Line |
   6 |    sqlcmd -b -Q "SELECT @@SERVERNAME as ServerName" 2>&1>$null
     |    ~~~~~~
     | The term 'sqlcmd' is not recognized as a name of a cmdlet, function,
     | script file, or executable program. Check the spelling of the name, or
     | if a path was included, verify that the path is correct and try again.
Error: Process completed with exit code 1.

[stevenobird]

See my comment here: microsoft/mssql-docker#914 (comment)

tl;dr: sqlcmd is not installed on the ubuntu24.04 runner image.
the reason is "due to maintenance reasons" according to this issue. Another reason could be the lack of official SQL Server support for Ubuntu 24.04 as of now.

Since this Action is utilizing the Docker image on Linux anyways, the action.yml could execute sqlcmd inside the docker image using docker exec instead of the locally installed sqlcmd.