exec sp_addlinkedserver
@server='server',@provider='sqloledb',@srvproduct='',@datasrc='localhost'

go

EXEC sp_addlinkedsrvlogin
@rmtsrvname = 'server', @useself = 'false', @locallogin = 'sa', @rmtuser = 'username', @rmtpassword = 'sa'
go