Bug: MSSQL Cannot run 'SELECT 1': container is not ready
envgap__testcontainers__testcontainers-python-666
01 / FAILURE SIGNATURE
As reported upstream
No identifying execution failure has been captured.
Not a benchmark task.
- The project already builds and runs before the fix, so there is nothing to repair.
02 / ENVIRONMENT RECIPE
- Base commit
2cf5a9fbe6db3fa4254a5bb54e67412ec2d08488- Manifest
pyproject.toml- Reproduce
Awaiting issue-specific recipe- Run under trace
Awaiting a meaningful runtime command
03 / ORIGINAL ISSUE TEXT
testcontainers/testcontainers-python #666 · read the original issue
**Describe the bug**
Microsoft changes the `mssql-tools` folder name to `mssql-tools18` at `2019-latest` and `2022-latest`. Testcontainer could not use the right path to check database status by mssql tool.
https://github.com/testcontainers/testcontainers-python/blob/e1e3d13b47923dd7124196e6b743799bd87b6885/modules/mssql/testcontainers/mssql/__init__.py#L55
Relate https://github.com/microsoft/mssql-docker/issues/892#issuecomment-2249029917
**To Reproduce**
```python
from testcontainers.mssql import SqlServerContainer
mssql = SqlServerContainer("mcr.microsoft.com/mssql/server:2019-latest").start()
```
**Solution**
We need to determine the exact location of the MSSQL tool before utilizing it.04 / LABELS
Labels from the report text only; not yet run
No supported category has been assigned.
Label rules and the text that matched
[]