Page 124 - DCAP508_DATABASE_ADMINISTRATION

Database Administration

Notes Options
1. Disabled Protocols: Lists protocols which are installed but are not currently used.
2. Enabled Protocols: Lists protocols which are available for Microsoft SQL Server clients on
this computer.
i. > Enables the currently highlighted protocol in the Disabled Protocols box, moving
it to the Enabled Protocols box.

ii. < Disables the currently highlighted protocol in the Enabled Protocols box, moving
it to the Disabled Protocols box.
Up arrow: Moves the highlighted protocol up in the list. This allows you to increase the
priority in which the Net-Library will attempt to use the selected protocol for connections.
Down arrow: Moves the highlighted protocol down in the list. This allows you to decrease
the priority in which the Net-Library will attempt to use the selected protocol for
connections.
3. Enable Shared Memory Protocol: Enables the shared memory protocol which is always
tried first (if enabled), when connecting to SQL Server from a client on that computer.

Notes If the protocol is specified through a prefix or as part of the connection string, only
the specified protocol is attempted.
8.3.2 Client Protocols – Shared Memory Properties (Protocol Tab)

In Microsoft SQL Server Configuration Manager use the Protocol tab on the Shared Memory
Properties dialog box to view or modify shared memory.

8.3.3 Client Protocols – TCP/IP Properties (Protocol Tab)

In Microsoft SQL Server Configuration Manager, use the Protocol tab on the TCP/IP Properties
dialog box to view or specify the following options. To connect to a different port, type the port
number in the Default Port box.
Default Port: Specifies the port that the TCP/IP Net-library will use to attempt to connect to the
target instance of SQL Server. The default value port is 1433.
When connecting to a default instance of Database Engine, the client uses this value. If a default
instance has been configured to listen on a different port, change this value to that port number.
When connecting to a named instance of Database Engine, the client will attempt to obtain the
port number from the SQL Server Browser Service running on the server computer. If the SQL
Server Browser Service is not running, the port number must be provided through this setting,
or as part of the connection string.

Enabled: Possible values are Yes and No.
Keep Alive: This parameter (in milliseconds) controls how often TCP attempts to verify that an
idle connection is still intact by sending a KEEPALIVE packet. The default is 30000 milliseconds.

Keep Alive Interval: This parameter (in milliseconds) determines the interval separating
KEEPALIVE retransmissions until a response is received. The default is 1000 milliseconds

118 LOVELY PROFESSIONAL UNIVERSITY