Dialogs - Add/Edit SQL Server

Last Updated: 01.06.2019
The Add/Edit SQL Server Dialog serves a dual purpose: to add a new instance of a SQL Server to the SQL Servers Window and to edit an existing or disconnected SQL Server.

When editing a server, the Server Name field will be disabled and labeled with the alias next to it in braces. If the server belongs to a group, it will be pre-selected in the Group drop-down. If the authentication or any of the connection properties are changed, the server will be disconnected and reconnected accordingly. If only the group or alias is changed, the dialog will close and apply the new changes without reconnecting.

Once a server is successfully connected to, it will be saved to an internal server list. These servers will appear in the Server Name drop-down box but only if they are NOT already in the SQL Servers Window. Selecting one of the saved servers will populate the Server Tab and Connection Properties Tab with the saved data.

Server Tab

The Server Tab is where you specify the SQL Server and Instance name, authentication type and whether the server should have an alias and/or belong to a group.

  • Server Name

    Enter the server name or IP Address along with the server instance name, if any. If the drop-down is expanded, any servers previously connected to will appear here, provided they are not already in the SQL Servers Window.

  • Authentication Type

    Choose between SQL Server Authentication or Windows Authentication. If using SQL Server Authentication, the User Name field is required but the Password field is not.

  • Remember Password

    When checked, the password entered will be encrypted using a symmetrical encryption algorithm and stored along with the rest of the connection data.

  • Group

    Select a group from the drop-down if desired. The contents of the drop-down will mimic the group structure as defined in the SQL Servers Window.

  • Alias

    If you would like to give the SQL Server an alias, type it in here. By default the alias will be named exactly like the server name with the exception of the instance name separator being replaced with a dash '-'. The alias is restricted to valid file system characters since it is used by the Decryption Wizard as part of the folder path. Characters such as " < > | * ? : / \ are not allowed.

Connection Properties Tab

The Connection properties Tab contains additional network and connection properties that can be used when connecting to a SQL Server.

  • Network Protocol

    Select a protocol from the list. The available client protocols are TCP/IP (default), Shared Memory and Multiprotocol.

  • Network Packet Size

    Enter the size of the network packets to be sent. The default is 4096 bytes.

  • Connection Time-out

    Enter the number of seconds to wait for a connection to be established before timing out. The default value is 15 seconds.

  • Execution Time-out

    Enter the amount of time in seconds to wait before execution of a task is completed on the server. The default value is zero seconds, which indicates there is no time-out.

  • Encrypt Connection

    Forces encryption of the connection.

DAC Information Tab

This tab contains instructions for setting up a DAC in both SQL Server and SQL Server Express. For more detailed information about the DAC please reference the The SQL Server DAC Connection topic.