Changing SQL server data source information

You can change the SQL Server data source information any time after you add it.

To change the SQL Server data source:

1. Open the Site Administrator Home page.

2. In the ODBC Data Source area, click List ODBC Data Sources.

3. On the List of Data Sources page, click the SQL data source you want to change.

4. Click the Edit tab.

• In the DSN Description text box, enter the description of the data source.

• In the Associated SQL Server text box, enter the SQL Server name, which is the host name of the remote/local SQL Server.

• In the Default Database Name text box, enter the name of the default database to be used.

5. Click Save to commit the changes made to the SQL Server data source.