MSSQL server 2016 (SP2) or higher version is not connecting after Sql Alchemy 1.4.15 version

[sidnaik03]

Describe the bug

Sql server 2016(SP2) successfully connecting up to sql alchemy 1.4.15 version. All version above 1.4.15 throws a connection error.

To Reproduce

from sqlalchemy import *
conn_str = 'mssql://USER:passsword@10.126.30.13:1433/ERPDB?driver=ODBC Driver 17 for SQL Server'
conn = create_engine(conn_str, echo=True)
conn.connect()
row = conn.execute('select count(*) from dbo.TEST')
print(row.rowcount)

Error

When I installed version 1.4.16 I got below error

(pyodbc.OperationalError) ('08001', '[08001] [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: A non-recoverable error occurred during a database lookup.\r\n (11003) (SQLDriverConnect); [08001] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0); [08001] [Microsoft][ODBC Driver 17 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. (11003)')

If I changed my sql alchemy version to 1.4.15 or lower its connecting properly

2022-10-20 07:39:20,453 INFO sqlalchemy.engine.Engine SELECT CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR)
2022-10-20 07:39:20,453 INFO sqlalchemy.engine.Engine [raw sql] ()
2022-10-20 07:39:20,456 INFO sqlalchemy.engine.Engine SELECT schema_name()
2022-10-20 07:39:20,456 INFO sqlalchemy.engine.Engine [generated in 0.00027s] ()
2022-10-20 07:39:20,459 INFO sqlalchemy.engine.Engine SELECT CAST('test max support' AS NVARCHAR(max))
2022-10-20 07:39:20,459 INFO sqlalchemy.engine.Engine [generated in 0.00028s] ()
2022-10-20 07:39:20,462 INFO sqlalchemy.engine.Engine select count(*) from dbo.TEST
2022-10-20 07:39:20,462 INFO sqlalchemy.engine.Engine [raw sql] ()

Versions

• OS: Windows 10
• Python: 3.9.10
• SQLAlchemy: 1.4.16 or higher
• Database: SQL Server 2016 SP
• DBAPI (eg: psycopg, cx_oracle, mysqlclient): pyodbc == 4.0.32

Additional context

I have tried to connect using only through pyodbc and its connected successfully.

[zzzeek]

hi

please ensure you dont have an unescaped @ sign in your password

please read: https://docs.sqlalchemy.org/en/14/core/engines.html#escaping-special-characters-such-as-signs-in-passwords

[sidnaik03]

Thank you. Its worked.Closing the issue.