Home > other >  Python pymssql failed to connect to SQL server server module
Python pymssql failed to connect to SQL server server module

Time:01-31

Error message is as follows:
Unhandled Exception "pymssql. OperationalError"
(18456, b "\ xe7 \ x94 \ xa8 \ xe6 \ x88 \ xb7 \ xe7 \ x99 \ 'the scaffold's test_new' XBB \ xe5 \ XBD \ x95 \ xe5 \ xa4 \ xb1 \ xe8 \ xb4 \ xa5 \ xe3 \ x80 \ x82DB - Lib error message 20018, 14: severity \ nGeneral SQL Server error: Check the messages from the SQL Server \ nDB - Lib error message 20002, severity 9: \ nAdaptive Server connection failed (2433) 10.114.144.11: \ n")
File: C: \ ProgramData \ Anaconda3 \ lib \ site - packages \ pymssql cp36 - win_amd64. Pyd, Line: 642

Go to the great spirit show

CodePudding user response:

O god, and he,

CodePudding user response:

Pymssql. OperationalError: (18456, b "\ xe7 \ x94 \ xa8 \ xe6 \ x88 \ xb7 \ xe7 \ x99 \ 'sa' XBB \ xe5 \ XBD \ x95 \ xe5 \ xa4 \ xb1 \ xe8 \ xb4 \ xa5 \ xe3 \ x80 \ x82DB - Lib error message 20018, 14: severity \ nGeneral SQL Server error: Check the messages from the SQL Server \ nDB - Lib error message 20002, severity 9: \ nAdaptive Server connection failed (adminstrator \ \ SQLEXPRESS) \ n")



With great strength is no problem, and finally the management studio input is essentially the sa account can't login, speculation should be account problem, finally choose server validation is used in the server properties and Windows authentication mode with respect to OK,? This tried?

CodePudding user response:

Connection error, the estimate or account, such as certification

CodePudding user response:

Reply amateurs Py whole stack engineer: you said this problem I have tried, but don't let our company modify choose server validation is used and Windows authentication mode, and the DBA colleague, don't give me login account open access and the sa account is disabled,

CodePudding user response:

reference oyljerry reply: 3/f
connection error, estimate or accounts, the problem of certification


Eh kindness I just want to make sure what is the problem, sad a rush,

CodePudding user response:

Remember try, before coding issues

CodePudding user response:

The building Lord, your database login account has a problem, check,
  • Related