how to transfer data from serverDB to Local system SQLDB

See more:

C#

SQL-Server

Hi,

I have used folowing queries to transfer data from server[74.56.432.561] to local system Sql[sw5]and also executed in sw5 SQL.

USE [master]
GO
EXEC master.dbo.sp_addlinkedserver
@server = 'xxx.xxx.xxx.xxx', @srvproduct='SQLOLEDB',
@provider='SQLOLEDB', --@datasrc=N'74.13.0.452\InstanceName'
@catalog='CineVistaDB'
GO
EXEC master.dbo.sp_addlinkedsrvlogin
@rmtsrvname = 'xxx.xxx.xxx.xxx', @locallogin = NULL , @useself = 'False',
 @rmtuser = 'universal', @rmtpassword = 'xxxxxxxxx'
GO

while running application with this query i'm getting an error that
Login Failed For universal

Please reply with an example