如何将数据从serverDB传输到本地系统SQLDB [英] how to transfer data from serverDB to Local system SQLDB

问题描述

我已经使用以下查询将数据从服务器[74.56.432.561]传输到本地系统Sql [sw5]，并且也在sw5 SQL中执行.

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

推荐答案

为什么您认为登录会失败?

1)因为用户名错误.
2)因为密码错误.

交给您...

Why do you think a login would fail?

1) Because the username is wrong.
2) Because the password is wrong.

Over to you...

这篇关于如何将数据从serverDB传输到本地系统SQLDB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！