Insert records from another SQL Server to my Local SQL Server.

[VMSERVER\MBWIN] is my remote Server.

[DEVELOPER04\MBWIN] is my Local Server

I had established connection with my Linked(remote) Server, run some validations and after finishing the requirements needed, i will then copy/insert records from table GLAC which is located in my Linked Server into my local table DLYGLACC which can be found in [DEVELOPER04\MBWIN].MBMIS..

Here's my code in copying/inserting of records;

strDLY = my local server ([DEVELOPER04\MBWIN].mbmis..DlyGlAcc)
strGL  = remote server ([VMSERVER].PUSAN_KRW_PROD.dbo.GLAC)
Conn = is my local connection

strSQL = "Insert Into " & strDLY & " Select * From " & strGL
Dim dx As New SqlDataAdapter(strSQL, conn)
Dim sx As New DataSet
dx.Fill(sx, "rDlyGlacc")

This error appeared;
Named Pipes Provider: Could not open a connection to SQL Server [1265]?