damodhar-admin opened a new issue, #36183: URL: https://github.com/apache/superset/issues/36183
### Bug description I am unable to connect MSSQL in Superset. Superset always shows this error: ERROR: Could not load database driver: MssqlEngineSpec. After checking deeply, I found that the latest Superset versions use SQLAlchemy 2.x, and SQLAlchemy 2.x has removed the MSSQL+pymssql dialect, so Superset cannot load the MSSQL engine anymore. Also, pymssql fails to install on all modern Docker images (Python ≥ 3.10, Debian 12) and Microsoft ODBC Driver 18 does not install on Debian 12. Because of all these issues, MSSQL is currently not supported in the newer Superset versions. Please confirm if MSSQL support has been officially dropped or if there is any recommended workaround to use MSSQL with Superset. ### Screenshots/recordings <img width="1909" height="815" alt="Image" src="https://github.com/user-attachments/assets/ca6b06e2-f435-49e3-b32d-9ebc39b28873"; /> ### Superset version 4.1.3 ### Python version 3.9 ### Node version I don't know ### Browser Chrome ### Additional context _No response_ ### Checklist - [x] I have searched Superset docs and Slack and didn't find a solution to my problem. - [x] I have searched the GitHub issue tracker and didn't find a similar bug report. - [x] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section. -- 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]
