Unable to connect to SQL Server databases with pycharm 2020.1.2
已回答
I just upgraded pycharm this morning to 2020.1.2, and now my existing connections as well as new connections to SQL Server databases don't work. When I try to execute a query (e.g. "select top 1000 * from sys.tables") I get a red error line at the bottom of the query window with just a single "." as the error, and the console shows:
[2020-06-08 11:46:33] .
When I try to make a new connection I also get an error icon with a single "." next to it after clicking "Test Connection".
Existing connections to Azure SQL databases still work fine.
Reverting to pycharm 2020.1 resolves the problems so SQL Server queries work again.
请先登录再写评论。
Yes it is known issue and here are workarounds
also you can use SQL Server integrated security instead of Windows auth.