domain name and connection string to SQL Server when using Python and pyodbc

Question

when using Windows authentification with domain name and connection string to SQL Server (using Python34 and pyodbc), I still receive the following error:

cnxn = pyodbc.connect('DRIVER={SQL Server Native Client 11.0};SER
N04\SQLEXPRESS;DATABASE=BRKPNTD',UID='CZMKAJAN04\celocaladmin', PWD='xxxxxx')
pyodbc.Error: ('28000', "[28000] [Microsoft][SQL Server Native Client
Server]Login failed for user 'CZMKAJAN04\\celocaladmin'. (18456) (SQLDriverConnect)")

I don't know how to get rid of the double backslash, tried raw version of the string, various forms of escaping and nothing helped. Do you know how to solve it? Thanks a lot

Perhaps: cnxn = pyodbc.connect('DRIVER={SQL Server Native Client 11.0};SER N04\SQLEXPRESS;DATABASE=BRKPNTD;UID=CZMKAJAN04\\celocaladmin;PWD=xxxxxx') would work better. — JNevill
– JNevill, Commented Oct 20, 2015 at 14:00

Bryan · Accepted Answer · 2015-10-20 16:39:07Z

2

Windows authentication for SQL Server connection strings requires the Trusted_Connection argument, it can't be specified using UID and PWD.

cnxn = pyodbc.connect('DRIVER={SQL Server Native Client 11.0};SERN04\SQLEXPRESS;DATABASE=BRKPNTD', Trusted_Connection='yes')

answered Oct 20, 2015 at 16:39

Bryan

17.7k7 gold badges59 silver badges81 bronze badges

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

Collectives™ on Stack Overflow

domain name and connection string to SQL Server when using Python and pyodbc

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related