SQL server

View connection method details on SQL server.

Clients can connect to SQL server using windows authentication or SQL sever authentication. On top of that, they can have a secure connection, use different protocols, use NTLM or Kerberos (more secure). To find out the properties of the client connections use the following: select session_id, net_transport, protocol_type, encrypt_option, auth_scheme, client_net_address, * from sys.dm_exec_connections.


Thinking about someting? Leave a Reply...

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s