Link to Different SQL Database

I had connect another SQL server VIA VPN , the server name is IP e,g
123.123.123.123
I can read the data sucessfully,
However, I want to insert some data from my local server.
sp_addlinked server '123.123.123.13'
sp_linkedserver (I can see it)
then select * from [123.123.123.123].database.dbo.myTable
I got an error said 'SQL Server does not exist or access denied'
Does any one can help , ThanksHi
You example shows two different IP addresses!!
John
"Agnes" wrote:

> I had connect another SQL server VIA VPN , the server name is IP e,g
> 123.123.123.123
> I can read the data sucessfully,
> However, I want to insert some data from my local server.
> sp_addlinked server '123.123.123.13'
> sp_linkedserver (I can see it)
> then select * from [123.123.123.123].database.dbo.myTable
> I got an error said 'SQL Server does not exist or access denied'
> Does any one can help , Thanks
>
>|||Sorry, the IP in my example should be the same
"John Bell" <jbellnewsposts@.h0tmail.com> glsD:7C2DF328-79A7-4836-912F-3A2CB6D803C
3@.microsoft.com...
> Hi
> You example shows two different IP addresses!!
> John
> "Agnes" wrote:
>|||Hi!
After adding the linked server you should tell SQL server which user on
local server may access remote server with system procedure
sp_addlinkedsrvlogin (see on BOL for details).
One useful idea is to add a name to the linked server in spite of the IP
address.
Hope that helps.
Joo Arajo
"Agnes" <agnes@.dynamictech.com.hk> escreveu na mensagem
news:OU2n3EvVFHA.2700@.TK2MSFTNGP12.phx.gbl...
>I had connect another SQL server VIA VPN , the server name is IP e,g
> 123.123.123.123
> I can read the data sucessfully,
> However, I want to insert some data from my local server.
> sp_addlinked server '123.123.123.13'
> sp_linkedserver (I can see it)
> then select * from [123.123.123.123].database.dbo.myTable
> I got an error said 'SQL Server does not exist or access denied'
> Does any one can help , Thanks
>|||I had process sp_addlinkedserverlogin , but still got error.
BTw, how can i alias the linked server name ?
THanks
"Joo Arajo" <joaoribeiroaraujo_DOMINIOIOL_@.nospam.PT> glsD:OF7DQ8zVFHA.3704@.TK2
MSFTNGP14.phx.gbl...
> Hi!
> After adding the linked server you should tell SQL server which user on
> local server may access remote server with system procedure
> sp_addlinkedsrvlogin (see on BOL for details).
> One useful idea is to add a name to the linked server in spite of the IP
> address.
> Hope that helps.
> Joo Arajo
> "Agnes" <agnes@.dynamictech.com.hk> escreveu na mensagem
> news:OU2n3EvVFHA.2700@.TK2MSFTNGP12.phx.gbl...
>|||Hi
Try something like:
EXEC sp_addlinkedserver @.server=3D'Remote_Svr', @.srvproduct=3D'',
@.provider=3D'SQLOLEDB',
@.datasrc=3D'123.123.123.123'
You can then use Remove_Svr as the name in your query. It sounds like
the login you are using does not have the correct permissions. You may
want to make sure that DTC is running on the server (although I would
expect a different message). You could use profiler on the remote
server to see what is happening.
John
Agnes wrote:
> I had process sp_addlinkedserverlogin , but still got error.
> BTw, how can i alias the linked server name ?
> THanks
> "Jo=E3o Ara=FAjo" <joaoribeiroaraujo_DOMINIOIOL_@.nospam.PT>
=BC=B6=BCg=A9=F3=B6l=A5=F3=B7s=BBD:OF7DQ
8zVFHA.3704@.TK2MSFTNGP14.phx.gbl...
user on
the IP
e,g|||Hi
Why should u put the IP Address in SELECT Statement , u can use the link
server Name '
U can also use the OPENQUERY for this as
SELECT * FROM OPENQUERY('SQL STATAEMENT')
Renjith
"Agnes" wrote:

> I had connect another SQL server VIA VPN , the server name is IP e,g
> 123.123.123.123
> I can read the data sucessfully,
> However, I want to insert some data from my local server.
> sp_addlinked server '123.123.123.13'
> sp_linkedserver (I can see it)
> then select * from [123.123.123.123].database.dbo.myTable
> I got an error said 'SQL Server does not exist or access denied'
> Does any one can help , Thanks
>
>sql