I was trying to connect PyCharm a SQL Server data source with Windows Authentication and noticed there was a dearth of resources on this issue.
I saw many posts about messing with your certificate store, but with my local server I don’t give a crap enough to secure it like that; if you are connecting to real servers where that matters with your client you may want to avoid these steps.
From my existing DBA/connection string experience I knew a security issue is almost always related to the certificates/encryption settings on the connection.
I tooled around the SSL/TLS settings and found nothing that changed any behavior – clearly the standard “uncheck encryption” trick isn’t managed through these checkboxes.
After an inexorable period I noticed the Driver: section, and of course the MSSQL driver settings are available directly.
Click the Advanced tab to get to the good stuff.
I updated integratedSecurity to true and encrypt to false. 
After that I had no more issues connecting to a local server.
Be First to Comment