HOW CAN I LINK TWO SQL SERVER

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.123'
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
Agnes,
Try sp_addlinked server '123.123.123.123', 'SQL Server'
See if that works.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"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.123'
> 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
>
>
|||sp_linkedservers
sp_addlinkedserver '123.123.123.123','SQL SERVER'
sp_addlinkedsrvlogin '123.123.123.123' <-- if i didn't specific
user, it will add everone
select * from [123.123.123.123].dts_master.dbo.port
I still got 'SQL Server does not exist or access denied.'
My EM had add this server succesfully , I can modify the structure ,preview
the data,
BUT still fail to link it up. That server got the firewall, Does the
firewall block me ?
"Mark Allison" <marka@.no.tinned.meat.mvps.org> glsD:F3E2A330-5023-418C-A4C4-F114D2292CB1@.microsoft.com...[vbcol=seagreen]
> Agnes,
> Try sp_addlinked server '123.123.123.123', 'SQL Server'
> See if that works.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
>
> "Agnes" wrote:
|||If you can see the server in EM it's not your FW that's blocking the access.
It might be your login to the linked server that isn't correct, so I'd
suggest you to look sp_addlinkedserver and sp_addlinkedsrvlogin in Books On
Line. There are some examples in there that might be helpfull.
Regards
Steen
Agnes wrote:[vbcol=seagreen]
> sp_linkedservers
> sp_addlinkedserver '123.123.123.123','SQL SERVER'
> sp_addlinkedsrvlogin '123.123.123.123' <-- if i didn't
> specific user, it will add everone
> select * from [123.123.123.123].dts_master.dbo.port
> I still got 'SQL Server does not exist or access denied.'
> My EM had add this server succesfully , I can modify the structure
> ,preview the data,
> BUT still fail to link it up. That server got the firewall, Does the
> firewall block me ?
>
> "Mark Allison" <marka@.no.tinned.meat.mvps.org>
> glsD:F3E2A330-5023-418C-A4C4-F114D2292CB1@.microsoft.com...