--Create the link to server "uranium"
EXEC master.dbo.sp_addlinkedserver
      @server = N'uranium',
      @srvproduct=N'',
      @provider=N'SQLNCLI'

--Add the catch-all login with SQL Server authentication
EXEC master.dbo.sp_addlinkedsrvlogin
      @rmtsrvname=N'uranium',
      @useself=N'False',
      @locallogin=NULL,
      @rmtuser=N'BatteryStaple',
      @rmtpassword='horsecorrect'

SELECT * FROM uranium.Periodic.dbo.Users

Msg 18456, Level 14, State 1, Line 1
Login failed for user 'BatteryStaple'.