|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
HOW CAN I LINK TWO SQL SERVERI 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. -- Show quoteMark 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 ?? Show quote "Mark Allison" <ma***@no.tinned.meat.mvps.org> ¼¶¼g©ó¶l¥ó·s»D:F3E2A330-5023-418C-A4C4-F114D2292***@microsoft.com... > 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 >> >> >> 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: Show quote > 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" <ma***@no.tinned.meat.mvps.org> > ¼¶¼g©ó¶l¥ó·s»D:F3E2A330-5023-418C-A4C4-F114D2292***@microsoft.com... >> 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  |
|||||||||||||||||||||||
Other interesting topics