python - 使用 pyodbc 连接到 SQL Server

Question

与此问题相关错误 28000: Login failed for user DOMAIN\\user with pyodbc

我能够解决那里列出的登录失败错误，但在添加 Trusted_Connection 参数后，我收到以下错误。知道如何解决这个问题吗？我按照这里的微软文档说明进行操作https://docs.microsoft.com/en-us/sql/connect/python/pyodbc/python-sql-driver-pyodbc?view=sql-server-2017

cnxn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password+';Trusted_Connection='+tc)


pyodbc.Error: ('HY000', "[HY000] [Microsoft][ODBC Driver 17 for 
SQL Server]SSPI Provider: Server (MSSQLSvc/<server>:<port>@<domain>) 
unknown while looking up 'MSSQLSvc/<server>:<port>@<domain>’ 
(cached result, timeout in 1073 sec) (851968) (SQLDriverConnect)")

标签： pythonpyodbc