Login failed for user '' when connecting to SQL Server using Python

Question

I am trying to connect to a SQL Server database with Python using this code:

conn = pyodbc.connect(
                  r'Driver={SQL Server Native Client 11.0};'    
                  r'Server=12345.dcd_ba.weatherton.com;'
                  r'Database=Dentrix;'
                  r'Trusted_Connection=no;'
                  r'Integrated security=false;'
                  r'username=fred;'
                  r'password=test;'
                 )
return conn

But I am getting this error:

pyodbc.InterfaceError: ('28000', "[28000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user ''. (18456) (SQLDriverConnect); [28000] [Microsoft][SQL Server Native Client 11.0]Invalid connection string attribute (0); [28000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user ''. (18456); [28000] [Microsoft][SQL Server Native Client 11.0]Invalid connection string attribute (0)")

FYI, a trusted connection, and integrated security are the same thing; there's no point declaring both. — Thom A
– Thom A ♦, Commented Jan 26, 2021 at 19:14

David Browne - Microsoft · Accepted Answer · 2021-01-26 19:57:58Z

1

According to Using Connection String Keywords with SQL Server Native Client it looks like you need to use UID instead of username

edited Jan 26, 2021 at 19:57

David Browne - Microsoft

90.7k7 gold badges52 silver badges87 bronze badges

answered Jan 26, 2021 at 19:10

Gab

3,5381 gold badge13 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gab Over a year ago

you are right @DavidBrowne-Microsoft I clarified my answer

Collectives™ on Stack Overflow

Login failed for user '' when connecting to SQL Server using Python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related