Error 28000: Login failed for user DOMAIN\\user with pyodbc

by

Connecting from a Windows machine:

With Microsoft’s ODBC drivers for SQL Server, Trusted_connection=yes tells the driver to use “Windows Authentication” and your script will attempt to log in to the SQL Server using the Windows credentials of the user running the script. UID and PWD cannot be used to supply alternative Windows credentials in the connection string, so if you need to connect as some other Windows user you will need to use Windows’ RUNAS command to run the Python script as that other user..

If you want to use “SQL Server Authentication” with a specific SQL Server login specified by UID and PWD then use Trusted_connection=no.

Connecting from a non-Windows machine:

If you need to connect from a non-Windows machine and the SQL Server is configured to only use “Windows authentication” then Microsoft’s ODBC drivers for SQL Server will require you to use Kerberos. Alternatively, you can use FreeTDS ODBC, specifying UID, PWD, and DOMAIN in the connection string, provided that the SQL Server instance is configured to support the older NTLM authentication protocol.

More Related Contents:

  1. How to speed up bulk insert to MS SQL Server using pyodbc
  2. Writing a csv file into SQL Server database using python
  3. Using SQL Server stored procedures from Python (pyodbc)
  4. to_sql pyodbc count field incorrect or syntax error
  5. Remote connection to MS SQL – Error using pyodbc vs success using SQL Server Management Studio
  6. Connecting to SQL Server 2012 using sqlalchemy and pyodbc
  7. pyodbc.connect() works, but not sqlalchemy.create_engine().connect()
  8. SQL / Pandas equivalent
  9. Working with an Access database in Python on non-Windows platform (Linux or Mac)
  10. Speeding up pandas.DataFrame.to_sql with fast_executemany of pyODBC
  11. python pip specify a library directory and an include directory
  12. Can’t open lib ‘ODBC Driver 13 for SQL Server’? Sym linking issue?
  13. Output pyodbc cursor results as python dictionary
  14. PYODBC–Data source name not found and no default driver specified
  15. pyodbc – How to perform a select statement using a variable for a parameter
  16. Get data from pandas into a SQL server with PYODBC
  17. stored procedures with sqlAlchemy
  18. Python call sql-server stored procedure with table valued parameter
  19. Unable to install pyodbc on Linux
  20. “Data source name not found and no default driver specified” with Access ODBC
  21. MSSQL2008 – Pyodbc – Previous SQL was not a query
  22. How to upsert pandas DataFrame to Microsoft SQL Server table?
  23. Pyodbc – “Data source name not found, and no default driver specified”
  24. pyodbc insert into sql
  25. How do I connect to SQL Server via sqlalchemy using Windows Authentication?
  26. Pyodbc error Data source name not found and no default driver specified paradox
  27. How to see the real SQL query in Python cursor.execute using pyodbc and MS-Access
  28. pyodbc the sql contains 0 parameter markers but 1 parameters were supplied’ ‘hy000’
  29. In Python, Using pyodbc, How Do You Perform Transactions?
  30. sql.h not found when installing PyODBC on Heroku

Leave a Comment