Your connection String should be like this: pyodbc.connect('DRIVER=' + driver +';SERVER=' + server +';PORT=1433' +';DATABASE=' + database +';UID=' + uid +';PWD='+ pwd + 'TrustServerCertificate=yes')