报错信息:
File "E:\PythonProject\WenSnap\venv\lib\site-packages\sql_server\pyodbc\base.py", line 307, in get_new_connection timeout=timeout)
django.db.utils.InterfaceError: ('28000', "[28000] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Login failed for user 'srsa'. (18456) (SQLDriverConnect); [28000] [Microsoft][ODBC Driver 13 for SQL Server]Invalid connection string attribute (0); [28000] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]**Login failed for user 'srsa'.** (18456); [28000] [Microsoft][ODBC Driver 13 for SQL Server]Invalid connection string attribute (0)")
我的django是2.0.4,windows操作系统 sqlser2012
按照网上所说的我已经安装了相应的包:
setting.py中DATABASE的配置如下
其中'driver': 'SQL Server Native Client 11.0' 和 'driver': 'ODBC Driver 13 for SQL Server' 报错一样,如最上边的报错
'driver': 'ODBC Driver 17 for SQL Server'的报错是:
django.db.utils.OperationalError: ('08001', '[08001] [Microsoft][ODBC Driver 17 for SQL Server]客户端不支持加密。 (21) (SQLDriverConnect); [08001] [Microsoft][ODBC Driver 17 for SQL Server]SQL Server 网络接口: 参数错误。\r\n (87); [08001] [Microsoft][ODBC Driver 17 for SQL Server]客户端无法建立连接 (21); [08001] [Microsoft][ODBC Driver 17 for SQL Server]无效的连接字符串属性 (0); [08001] [Microsoft][ODBC Driver 17 for SQL Server]与 SQL Server 建立连接时发生了与网络相关的或特定于实例的错误。找不到或无法访问服务器。请检查实例名称是否正确以及 SQL Server 是否配置为允许远程连接。有关详细信息,请参阅 SQL Server 联机丛书。 (87)')
请各位大神帮忙看看