Python to SQL connection issues

Question

Try to connect Python to SQL with this
import pyodbc
conn = pyodbc.connect("Driver={SQL Server Native Client 11.0};"
"Server=DELLPRECISION;"
"Database=AventureWork2017;"
"UID=DELLPRECISION\sa"
"PWD=password;"
"Trusted_Connection=no;")
and got error
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
pyodbc.InterfaceError: ('28000', "[28000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'DELLPRECISION\sa'. (18456) (SQLDriverConnect); [28000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'DELLPRECISION\sa'. (18456)")

Not sure why?

Answer 1

Hi @qp ,

> Login failed for user 'DELLPRECISION\sa'. (18456)"

Please make sure the login 'DELLPRECISION\sa' is existed and the login is enabled for this SQL server instance. Check this from SSMS > under the Object Explorer menu > Security > Logins. Please also make sure the login is spelled correct and the password is correct.

If you adding the user ID and PWD, suggest you removing the ‘Trusted_Connection’ parameter in connection string.

Please refer to the blog How to Connect Python to SQL Server using pyodbc and the thread Connecting to Microsoft SQL server using Python to get more detail information.

---

If the response is helpful, please click "Accept Answer" and upvote it, thank you.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Did you try UID=sa instead of UID=DELLPRECISION\sa?

Answer 3

I did and same error.