import pyodbc
# Connection details
server = 'your_server_name'
database = 'your_database_name'
username = 'your_username'
password = 'your_password'
# Connect to SQL Server instance
conn_str = f"DRIVER={{SQL Server}};SERVER={server};DATABASE={database};UID={username};PWD={password}"
conn = pyodbc.connect(conn_str)
# Get the port number
cursor = conn.cursor()
cursor.execute("SELECT local_tcp_port FROM sys.dm_exec_connections WHERE session_id = @@SPID")
port_number = cursor.fetchone()[0]
# Print the port number
print(f"The port number for this SQL Server instance is {port_number}")
# Close the connection
conn.close()