On the destination database, run:
exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure
Run copy:
INSERT INTO [DEV].[dbo].[tblUser]
([ID]
,[Name])
SELECT
*
FROM
OPENDATASOURCE('SQLOLEDB', 'Data Source=192.168.1.103,3422;User ID=sa;Password=YourPWD;').databaseName.dbo.tableName
