Creating the user mappings for a Microsoft SQL Server data source

When you attempt to access an Microsoft SQL Server remote server, the federated server establishes a connection to the Microsoft SQL Server remote server by using a user ID and password that are valid for that data source.


Issue a CREATE USER MAPPING statement.
For example:
CREATE USER MAPPING FOR local_userID SERVER server_definition_name
       OPTIONS (REMOTE_AUTHID 'remote_userID', REMOTE_PASSWORD 'remote_password');

What to do next

After you complete this task, you can test the connection to the Microsoft SQL Server tables and views.