使用带有'Windows凭据'的Linux上的python连接到MS SQL Server

pip install pyodbc

sudo apt-get install freetds-dev freetds-bin

[global]
    tds version = 7.0

[myserver]
    host = myserver.example.com
    port = 1433
    tds version = 7.0

import pyodbc

server = 'myserver.example.com'
database = 'mydatabase'
username = 'myusername'
password = 'mypassword'

cnxn_string = f"DRIVER={{FreeTDS}};SERVER={server};DATABASE={database};UID={username};PWD={password}"

cnxn = pyodbc.connect(cnxn_string)

cursor = cnxn.cursor()

cursor.execute("SELECT * FROM mytable")

row = cursor.fetchone()
while row:
    print(row)
    row = cursor.fetchone()

sudo apt-get install wine winbind

sudo nano /etc/samba/smb.conf

netbios name = MYDOMAIN
workgroup = MYWORKGROUP
security = domain

sudo service winbind restart

import pyodbc

server = 'myserver.example.com'
database = 'mydatabase'
trusted_connection = 'yes'

cnxn_string = f"DRIVER={{FreeTDS}};SERVER={server};DATABASE={database};Trusted_Connection={trusted_connection}"

cnxn = pyodbc.connect(cnxn_string)

cursor = cnxn.cursor()

cursor.execute("SELECT * FROM mytable")

row = cursor.fetchone()
while row:
    print(row)
    row = cursor.fetchone()