On federated servers that run Windows,
the federated server must be able to access Microsoft SQL
Server data sources. To prepare the federated server, you must verify
the settings in the ODBC System DSN and test the connection to Microsoft SQL Server data sources.
Procedure
- Verify that the ODBC System DSN is set to connect to the Microsoft SQL Server data source. In the
Control Panel, locate the existing DSN entry for the Microsoft SQL Server remote server or create
a DSN entry.
The DSN entry for the Microsoft SQL
Server remote server is the value that you will use for the NODE server
option when you register the server definition in the federated database.
- Use one of the following methods to test the connection
to the Microsoft SQL Server data source:
- Select Configure from the ODBC Data
Source Administrator window.
- Use the Microsoft SQL Server query
tool.
What to do next
After you complete this task, you can set the environment
variables.