CODEWITHSUNDEEP
pythonsql-serverflasksqlalchemypymssql
Simon Melouah
Simon Melouah

Reputation: 652

Connecting Python to MSSQL using Pymssql

I'm having an issue connecting a live system to a new MSSQL database instance through Pymssql. I've no problem connecting to the previous old instance, but when I change the connection string to the new one and reload my code in apache I get the following authentication error:

sqlalchemy.exc.OperationalError: (pymssql.OperationalError) (18456, "Login failed for user '*****'.DB-Lib error message 20018, severity 14:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (*********************)\n")

The problem is, the exact same connection (with the same login details) works fine locally. I can login and access the new database instance through Pymssql with no issues. I'm assuming my FreeTD's are up to date as well seeing as I can connect fine to the old instance. Any suggestions would be greatly appreciated as to why the new connection won't work for the live system.

Upvotes: 2

Views: 4466

Answers (1)

Simon Melouah
Simon Melouah

Reputation: 652

Ok so the issue was that pymssql has an upper password limit of 30 characters. My new instance connection password exceeded this. Just in case anybody has the same problem.

Upvotes: 7

Related Questions