how to add a user on another server to sql as a user code example
Example: create user sql server
/*You can also create a login using the T-SQL command.*/
CREATE LOGIN MyLogin WITH PASSWORD = '123';
/*You can also create a login using the T-SQL command.*/
CREATE LOGIN MyLogin WITH PASSWORD = '123';