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.
CREATE USER MAPPING FOR local_userID SERVER server_definition_name OPTIONS (REMOTE_AUTHID 'remote_userID', REMOTE_PASSWORD 'remote_password');
After you complete this task, you can test the connection to the Microsoft SQL Server tables and views.