Skip to content

Add support for Windows Authentication (Trusted Connections) for MS SQL Server #56

@Artmann

Description

@Artmann

Add an option to use Windows Authentication (trusted connections) when connecting to MS SQL Server databases, as an alternative to SQL Server Authentication with username/password.

Windows Authentication allows users to connect to SQL Server using their Windows/Active Directory credentials without specifying a username and password in the connection string. This is the preferred authentication method in many enterprise environments because:

  • No credentials stored in connection strings or environment variables
  • Centralized access management through Active Directory
  • Better audit trails and compliance
  • Support for Kerberos delegation

Proposed Implementation

In SQLAlchemy, trusted connections are enabled by adding trusted_connection=yes to the connection URL or using Integrated Security=SSPI:

# Option 1: Using the trusted_connection parameter
engine = create_engine(
    "mssql+pyodbc://myserver/mydb?driver=ODBC+Driver+17+for+SQL+Server&trusted_connection=yes"
)

# Option 2: Using Integrated Security
engine = create_engine(
    "mssql+pyodbc://myserver/mydb?driver=ODBC+Driver+17+for+SQL+Server&Integrated_Security=SSPI"
)

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions