Databases
General Info
Useful Snippets

5.0.3 SQL Server Connection Trusted Connection

Description:

The nice thing about a trusted connection is that you don't have to worry about storing or using your password in your code.

Example:

# you may need to set up an ODBC Driver on your computer before this will work
SQL_Server_Engine = sqlalchemy.create_engine('mssql+pyodbc://your.server.address.org/database_name?driver=ODBC Driver 13 for SQL Server?Trusted_Connection=yes')