How to connect to Local MS SQL Express Edition using Python 3

Question

I am trying to connect to local MS SQL Express Edition. I am using canopy for Python editing.

Code:

import pymssql

conn = pymssql.connect(server='******\SQLEXPRESS',user = 'MEA\*****',password='*****',database='BSEG')

cursor = conn.cursor()

cursor.execute('SELECT * FROM Table')
print(cursor.fetchone())

conn.close()

Error::

pymssql.pyx in pymssql.connect (pymssql.c:10734)()

_mssql.pyx in _mssql.connect (_mssql.c:21821)()

_mssql.pyx in _mssql.MSSQLConnection.init (_mssql.c:5917)()

ValueError: too many values to unpack (expected 2)

sepupic · Accepted Answer · 2017-09-09 18:35:20Z

0

user = 'MEA\*****',password='*****'

MEA\***** seems to be Windows login, in this case you shouldn't pass in any password, your user name is enough, but you also should use Integrated security or Trusted parameter in your connection string

It should be smth like this:

server='******\SQLEXPRESS',Trusted_Connection=yes,database='BSEG'

edited Sep 9, 2017 at 18:35

answered Sep 9, 2017 at 18:17

sepupic

8,7371 gold badge11 silver badges21 bronze badges

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

2 Comments

Anuj Agarwal Over a year ago

Yes I am using windows login. Could you please provide me with the proper connection string.

sepupic Over a year ago

I updated the answer, also, take a look here: stackoverflow.com/questions/16515420/…

Jorge Raigoza · Accepted Answer · 2023-03-21 14:59:12Z

0

In my local machine I only have the sql express instance, then after some tryes I get that server can be just ".". the user that I am using is sa

answered Mar 21, 2023 at 14:59

Jorge Raigoza

111 silver badge1 bronze badge

Collectives™ on Stack Overflow

How to connect to Local MS SQL Express Edition using Python 3

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related