Breaking News: Grepper is joining You.com. Read the official announcement!

ms sql port

YOU.com answered on January 28, 2021 Popularity 10/10 Helpfulness 2/10

answer ms sql port

related sql server port number

ms sql port

Comment

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()

Popularity 10/10 Helpfulness 2/10 Language python

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

Closely Related Answers

sql server port number

Comment

By default SQL Server listens on TCP port number 1433, but for named instances the TCP port is dynamically configured. There are several options available to get the listening port for a SQL Server named instance.

Popularity 10/10 Helpfulness 2/10 Language sql

Source: popdock.com

Tags: port-number port

Link to this answer
Share Copy Link

Contributed on Jan 28 2021

unmeego

0 Answers Avg Quality 2/10

ms sql port

Contents

More Related Answers

ms sql port

Closely Related Answers

sql server port number

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.