[GH-ISSUE #274] About MS SQL #83

New issue

Open

opened 2026-02-26 01:33:04 +03:00 by kerem · 1 comment

kerem commented

2026-02-26 01:33:04 +03:00

Owner

Originally created by @michliu on GitHub (May 19, 2022).
Original GitHub issue: https://github.com/jeffknupp/sandman2/issues/274

How to connect to MS SQL ? DB_TYPE=? / DB_DRIVER=?

Originally created by @michliu on GitHub (May 19, 2022). Original GitHub issue: https://github.com/jeffknupp/sandman2/issues/274 How to connect to MS SQL ? DB_TYPE=? / DB_DRIVER=?

kerem commented

2026-02-26 01:33:05 +03:00

Author

Owner

@educostadev commented on GitHub (Dec 21, 2022):

DB_TYPE=mssql and DB_DRIVER=pymssql

You can connect to your SQL Server using:

sandman2ctl mssql+pymssql://sa:PASSWORD@localhost:1433/master

I had to install sandman2, pymssql and upgrade the SQLAlchemy version

pip install sandman2 pymssql
pip install Flask-SQLAlchemy==2.5.1

@educostadev commented on GitHub (Dec 21, 2022): DB_TYPE=mssql and DB_DRIVER=pymssql You can connect to your SQL Server using: ``` sandman2ctl mssql+pymssql://sa:PASSWORD@localhost:1433/master ``` I had to install sandman2, pymssql and upgrade the SQLAlchemy version ``` pip install sandman2 pymssql pip install Flask-SQLAlchemy==2.5.1 ```