有会python的大佬吗,数据库连接,我连接sqlserver失败报错了
下面两种都不行
db = pymssql.connect(server='远程地址', port='1439', user='账号', password='密码',database='数据库名称',charset='utf8')
报错:pymssql._pymssql.OperationalError: (20009, b’DB-Lib error message 20009, severity 9:\nUnable to connect: Adaptive Server is unavailable or does not exist (远程地址)\nNet-Lib error during Unknown error (10060)\nDB-Lib error message 20009, severity 9:\nUnable to connect: Adaptive Server is unavailable or does not exist (远程地址)\nNet-Lib error during Unknown error (10060)\n’)
db = pymssql.connect(host='远程地址', port='1439', user='账号', password='密码',database='数据库名称',charset='utf8')
pymssql._pymssql.OperationalError: (20009, b’DB-Lib error message 20009, severity 9:\nUnable to connect: Adaptive Server is unavailable or does not exist (远程地址)\nNet-Lib error during Unknown error (10060)\nDB-Lib error message 20009, severity 9:\nUnable to connect: Adaptive Server is unavailable or does not exist (远程地址)\nNet-Lib error during Unknown error (10060)\n’)
如果我没记错的话 SqlServer端口默认是 1433