Last Updated: 04.01.2016
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
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.
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.
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.
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.
When checked, the password entered will be encrypted using a symmetrical encryption algorithm and stored along with the rest of the connection data.
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.
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.
The Connection properties Tab contains additional network and connection properties that can be used when connecting to a SQL Server.
Select a protocol from the list. The available client protocols are TCP/IP (default), Shared Memory and Multiprotocol.
Enter the size of the network packets to be sent. The default is 4096 bytes.
Enter the number of seconds to wait for a connection to be established before timing out. The default value is 15 seconds.
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.
Forces encryption of the connection.
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