EXEC sp_addlinkedserver @server = 'OPSERVER', @srvproduct = 'SQL Server'

EXEC sp_addlinkedsrvlogin @rmtsrvname = 'OPSERVER', @rmtuser = 'SA', @rmtpassword = 'SA'

SELECT * FROM OPSERVER.VENUS.dbo.TABL1

EXEC sp_addlinkedserver @server = 'OPSERVER', @srvproduct = 'SQL Server'

sp_addlinkedsrvlogin
  @rmtsrvname = 'OPSERVER',
  @locallogin = 'sa',
  @rmtuser = 'sa',
  @rmtpassword = 'sa'

SELECT * FROM OPSERVER.VENUS.dbo.TABLE1



Showing error as "Login failed for user 'sa'"

EXEC sp_addlinkedsrvlogin @rmtsrvname = 'OPSERVER', @rmtuser = 'SA', @rmtpassword = 'RemoteSaPassword'

sp_addlinkedsrvlogin
  @rmtsrvname = 'OPSERVER',
  @locallogin = 'sa',
  @rmtuser = 'sa',
  @rmtpassword = 'RemoteSaPassword'

sp_addlinkedsrvlogin
  @rmtsrvname = 'OPSERVER',
  @locallogin = 'domainusername',
  @rmtuser = 'sa',
  @rmtpassword = 'RemoteSaPassword'

sp_addlinkedsrvlogin
  @rmtsrvname = 'OPSERVER',
  @useself = 'TRUE'

sp_addlinkedsrvlogin
  @rmtsrvname = 'OPSERVER',
  @useself='false',
  @locallogin = 'sa',
  @rmtuser = 'sa',
  @rmtpassword = 'RemoteSaPassword'