Editing a data source

You use the Edit Datasource page to edit the details of data sources. If the Enterprise server is currently running when you edit a data source's properties, you need to restart the server afterwards to apply your changes.

To access the Edit Datasource page, on the Datasources page, click the Actions dropdown underneath the data source you want to edit, then click Edit.

To edit a data source:

1. Enter a name with which to identify the data source in the Name field.
2. In the Server field, enter the IP address of the machine on which SQL Server is located, followed by the port number that was specified in the TCP/IP pipes connection during initial setup of SQL Server. The IP address and port number must be separated by a comma and a space, for example 192.168.152.208, 1433. The port number is 1433 by default.
3. Enter the name of the SQL Server database that corresponds to the data source in the Database field.
4. Enter the user name and password of the SQL Server user you have created in the Username and Password fields.
   
   Select the Show password check box if you want the password to be displayed as you type it, or clear this check box if you want it to be obscured.
5. Click Save. The data source details are saved and you return to the Data sources page.

Related Topics:

Working with data sources

Working with Enterprise servers