Friday, March 30, 2012

Link two internal sql-servers

Hi!
I have a network with two sql-servers.
One which we can call LOCAL1 is a sql-server with a non public ip-adress.
Another one which we can call PUBLIC1 which is a sql-server with a
public ip-adress.
I have setup one account on each server for connection to the pubs-database.
I add linked server with sp_addlinkedserver on booth servers and also
adds logins with sp_addlinkedsrvlogin.
Evrything seems fine.
When I login with my account that I just setup on the local server with
QA and the query like this
select * from PUBLIC1.pubs.dbo.authors
everything is fine and it works perfect.
But when I login with my account on the public server with QA and query
like this
select * from LOCAL1.pubs.dbo.authors
I get this response after 21 seconds:
Server: Msg 17, Level 16, State 1, Line 1
SQL Server does not exist or access denied.
I am using booth named pipes and TCP/IP on booth the client and the server.
I have tried to add the local server to the public servers hosts file.
But it didnt help.
Any suggestions?
Thanks!Start here:
Potential causes of the "SQL Server Does Not Exist or Access Denied" error
message
http://support.microsoft.com/defaul...kb;en-us;328306
Firewall in between maybe?
HTH
Dylan
"dotNet" <dotnet@.brimba.nu> wrote in message
news:eqmmDXbXEHA.4032@.TK2MSFTNGP11.phx.gbl...
> Hi!
> I have a network with two sql-servers.
> One which we can call LOCAL1 is a sql-server with a non public ip-adress.
> Another one which we can call PUBLIC1 which is a sql-server with a
> public ip-adress.
> I have setup one account on each server for connection to the
pubs-database.
> I add linked server with sp_addlinkedserver on booth servers and also
> adds logins with sp_addlinkedsrvlogin.
> Evrything seems fine.
> When I login with my account that I just setup on the local server with
> QA and the query like this
> select * from PUBLIC1.pubs.dbo.authors
> everything is fine and it works perfect.
> But when I login with my account on the public server with QA and query
> like this
> select * from LOCAL1.pubs.dbo.authors
> I get this response after 21 seconds:
> Server: Msg 17, Level 16, State 1, Line 1
> SQL Server does not exist or access denied.
> I am using booth named pipes and TCP/IP on booth the client and the
server.
> I have tried to add the local server to the public servers hosts file.
> But it didnt help.
> Any suggestions?
> Thanks!|||Hi!
I have looked there.
I found that I cannot even telnet from the local1 to localhost
telnet localhost 1433
this works perfect on the public server...
I can ping localhost and the local ip as well.
But I can connect with QA to local1 and run queries...
What can this be?
I dont have any firewall on the local1-server.
Thanks
Dylan Kruger[MS] wrote:

> Start here:
> Potential causes of the "SQL Server Does Not Exist or Access Denied" error
> message
> http://support.microsoft.com/defaul...kb;en-us;328306
> Firewall in between maybe?
> HTH
> Dylan
> "dotNet" <dotnet@.brimba.nu> wrote in message
> news:eqmmDXbXEHA.4032@.TK2MSFTNGP11.phx.gbl...
>
> pubs-database.
>
> server.
>
>
>

No comments:

Post a Comment