In my reproducible example I used SQLAlchemy and CONVERT the timestamp to text before reading it, to ensure no conversion/data loss happened during reading the data. This demonstrates that the problem ...
This package requires TCP/IP to connect to SQL Server, and you may need to enable this in your installation.