Use this dialog box to view the current connection properties. This dialog box is available when you click View connection properties in various Object Explorer dialog boxes. The properties displayed on this page are read-only.
To change properties such as Database, connect to the desired database with Object Explorer before opening the Connection Properties dialog box.
Note that the query time-out period for SQL Azure is 30 minutes.
View authentication properties for the current connection. Authentication properties are the login and authentication method when the connection was established. To change the authentication properties, disconnect from Microsoft SQL Server, and then connect Object Explorer to the server again, using the desired connection options.
The authentication method used for the current connection.
The name of the user of login used for the connection authentication.
View connection properties for the current connection. Most connection properties were selected on the Connection Properties tab of the Connect to server dialog box during the connection process.
The name of the database currently connected to. To change this use, the SQL Editor toolbar.
The system process ID assigned by the server to the connection. This cannot be changed for this connection.
The network protocol of the SQL Server Management Studio connection. To change this, connect again with the desired connection properties.
Network Packet Size
The packet size used when communicating with the server. To change this, connect again with the desired connection properties.
The amount of time is seconds to wait when connecting to SQL Server before timing out and returning a failure to connect error to the user. To change this, connect again with the desired connection properties.
The amount of time in seconds to wait before execution of a task is completed on the server. To change this, connect again with the desired connection properties.
Whether the current connection is encrypted. To change this, connect again with the desired connection properties.