By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,886 Members | 1,359 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,886 IT Pros & Developers. It's quick & easy.

Link Different Sever problem

P: n/a
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
Nov 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Have you used the sp_addlinkedsrvlogin to map logins between your local db
and the remote db? Please see BOL for info on how to use this stored
procedure.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:eQ**************@TK2MSFTNGP14.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

Nov 21 '05 #2

P: n/a
On Thu, 12 May 2005 14:57:46 +0800, "Agnes" <ag***@dynamictech.com.hk>
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


sp_addlinkedserver doesn't try to connect to the server, neither does
sp_linkedservers. You can even specify a non-existing computername or one
that's off-line, it will still succeed.

A connection is made only when you execute a query against one of its
databases.

My best guess is that you really don't have access from where your code is
running.
I thought it could be caused by the SQL Server service running under the
local system account, but that's only for replication: I just tried, and
got access to another server perfectly while both were running under the
local system account (of their respective machines).

Nov 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.