dosubot[bot] commented on issue #36183: URL: https://github.com/apache/superset/issues/36183#issuecomment-3552040461
<!-- Greeting --> Hi @damodhar-admin! I'm [Dosu](https://go.dosu.dev/dosubot) and I’m helping the superset team. <!-- Answer --> MSSQL support has not been officially dropped in Superset 4.1.3. The MssqlEngineSpec is still present and maintained in the codebase, and the documentation continues to list both pymssql and pyodbc as supported drivers for connecting to SQL Server databases. The error you’re seeing usually means the required driver (pymssql or pyodbc) is not installed in your Superset environment, which is common with recent Docker images that no longer include database drivers by default[^1][^2][^3]. **Workarounds:** - The recommended fix is to create a custom Docker image based on the official Superset image and install the required driver. For example, add `RUN pip install pymssql` or `RUN pip install pyodbc` to your Dockerfile and rebuild your image[^1][^2]. - For local development, you can add `pymssql` or `pyodbc` to a `requirements-local.txt` file in your `./docker` directory and rebuild the Docker stack[^1]. - If you have trouble with `pymssql` (especially on newer Python/Debian versions), try using `pyodbc` with the `mssql+pyodbc` connection string. Make sure to install the appropriate Microsoft ODBC driver for your OS and use a URL-encoded connection string as shown in the docs[^3]. **References:** - [Superset official docs: SQL Server connection & driver install](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/docs/docs/configuration/databases.mdx#L102-L1281) - [Example workaround and Dockerfile snippet](https://github.com/apache/superset/issues/32874) - [Discussion of driver installation in Docker images](https://github.com/apache/superset/discussions/31775) [^1]: https://github.com/apache/superset/issues/32874 [^2]: https://github.com/apache/superset/discussions/31775 [^3]: https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/docs/docs/configuration/databases.mdx#L102-L1281 <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/55f92d08-741c-4ed6-872d-6d15d0e8d457?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/55f92d08-741c-4ed6-872d-6d15d0e8d457?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/55f92d08-741c-4ed6-872d-6d15d0e8d457?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/55f92d08-741c-4ed6-872d-6d15d0e8d457?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/55f92d08-741c-4ed6-872d-6d15d0e8d457?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/55f92d08-741c-4ed6-872d-6d15d0e8d457?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/55f92d08-741c-4ed6-872d-6d15d0e8d457?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=githu b) [](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/issues/36183) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
