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.
Procedure
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');