Editing Server Settings

The following procedure describes how to edit Server Settings for an SQL Server.

To edit server settings:

From Studio's File Manager, click the SQL tab.
From the list of SQL Servers currently defined for Studio, select a server, right-click and select the Settings option.
The SQL Server Settings dialog box opens for that server.
Enter the SQL Server Settings in the fields provided.
The settings include:

	Server Type - When updating a server the list of server types sis disabled (Create a new server definitions if the server type needs to be changed).
	Server Name (Alias) - The name of the server that will appear on the SQL Tree (of the File Manager).
	Host Name/IP - Address of the server.
	Port - The default port can be manually edited.
	Database Name - The name of the database that the server connects to. This field is names as SID in Oracles connections and as Database File in SQLite "flat-file" database connections.
	User Name - Your approved User Name for the server.
	Password - The correct Password for the User Name.

Enter the Connection Preferences using the checkboxes provided.
The preferences include:

	Save Password - Saves the Password.
	Connect When Zend Studio Starts - Connects to the server whenever Zend Studio starts.
	Auto Reconnect - If the connection to the server is broken, Auto Reconnect attempts 3 times to reconnect. If it is unable to reconnect, it then registers a "disconnect" and Auto Reconnect will stop working.
	Test the Connection Every - Checks every n seconds to see if the server is responsive. Use the Seconds field to enter your preference.

Click Test to attempt to connect to the SQL Server using the settings and connections currently entered in the Add SQL Server dialog box.
Click OK to accept the settings and preferences you have entered.

Related Links:
SQL Settings

Connecting to an SQL Server