To configure the federated server to access Microsoft SQL Server data sources, you
must provide the federated server with information about the data
sources and objects that you want to access.
Before you begin
- The ODBC driver must be installed and configured on the federated
server.
- Federation must be installed on a server that acts as the federated
server.
- Check the setup of the federated server.
- Check the federated parameter to ensure that federation is enabled.
Procedure
- Use one of the following methods to prepare the federated
server and federated database depending on your operating system.
- Set the environment
variables for the Microsoft SQL Server wrapper.
- Register the wrapper.
- Register the server
definition.
- Create the user
mappings.
- Test the connection
to the Microsoft SQL Server remote server
- Register nicknames
for Microsoft SQL Server tables and views.