RE: Link servers through proxy

changliw@xxxxxxxxxxxxxxxxxxxx (Charles Wang[MSFT]) wrote in
news:MbNRiawsHHA.3896@xxxxxxxxxxxxxxxxxxxxxx:

Hi David,
Sorry for the misunderstanding.

I had noticed that you said:
"I can use SQL 2000 Enterprise Manager, Query Analyzer, and SQL 2005
Management Studio to access several database on the SQLREMOTE server
(default instance) using TCP/IP and an alias that I have set up, with
a specific port number."
I had thought that there was a SQL Server on your DEV computer.

If you do not want to install a SQL Server on your DEV computer, you
need to at least allow one direction of the network communications
accessible from SQLTest to SQLREMOTE or SQLREMOTE to SQLTest. Assume
that you can access SQLREMOTE from SQLTest, you can run the T-SQL
statement from SQLTest to fetch data from SQLREMOTE.

Of course you can also develop an application for extracting data from
SQLREMOTE to SQLTest. In this case, SQLREMOTE and SQLTest need not to
know each other.

Appreciate your understanding that our SQL Server newsgroup is focused
on break/fix issue of SQL Server. It seemed that this is a network
configuration issue, if my suggestions here are not your appropriate
for your situation, I recommend that you contact your network
administrator or have a new post at the community
microsoft.public.windows.server.networking for the most appropriate
assistance.

If you have any other questions or concerns, please feel free to let
us know.

Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================

Thanks, I got the connection to work by the correct setup of the port
forwarding through the proxy server on my DEV machine.

I have a somewhat-related problem which I will put in a new post...
since I don't think it's a proxy issue.

Thanks for your help.

David Walker

.

Relevant Pages

  • RE: Link servers through proxy
    ... I understand that you would like to fetch data from SQLREMOTE into SQLTEST ... Server Enterprise Manager, expand your server and Data Transfermation ... add SQLREMOTE and SQLTEST as linked servers in your SQL Server on the DEV ...
    (microsoft.public.sqlserver.connect)
  • Link servers through proxy
    ... My main development computer, XP Pro, has 2 Ethernet ... Management Studio to access several database on the SQLREMOTE server ... I can see the databases on the SQLTEST computer ...
    (microsoft.public.sqlserver.connect)
  • RE: Link servers through proxy
    ... Management Studio to access several database on the SQLREMOTE server ... I had thought that there was a SQL Server on your DEV computer. ... from SQLTest to SQLREMOTE or SQLREMOTE to SQLTest. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.connect)
  • RE: Link servers through proxy
    ... I understand that you would like to fetch data from SQLREMOTE into ... SQLTEST via your DEV computer since it can see both SQLREMOTE and ... your SQL Server on the DEV computer. ... I don't have a SQL server on the DEV computer -- I'm just running ...
    (microsoft.public.sqlserver.connect)
Loading