Re: Connection from remote computer to network SQL Server

or Access Data Projects; I mean-- this is in a ADP channel

ADP works like a charm 'over the internet' and 'over a VPN'

MDB sucks

we just need to get to the root of this posting; are you using ADP or
MDB?

-Aaron



Sylvain Lafontaine (fill the blanks, no spam please) wrote:
You must tell the Firewall/router to open the port 1433 and to redirect it
to the Win2K machine. On many routers, this is called Port Forwarding and
is often located under the Advanced options. Take a look around and you
should find it.

Normally, forwarding a port will open it through the firewall but not
necessarily. Take a look at your documentation.

To find the IP address of your computer inside the network, look at the list
of attached devices in your router or open a CMD (or DOS) session on your
local machine and run the command IPCONFIG /all. It's also a good idea to
give a fixed local address to your machine on your router; something that
you should find under the LAN IP setup of your router.

When you're done, all you have to do will be to give the fixed IP address of
the network as the name of the machine; the router will do the rest when it
will receive a connection on the port 1433 and redirect it to your Win2K
server. It's best to add ,1433 at the end to make sure that the OBDC or
OLDB provider will know that this is a TCP/IP address but it should work
without it. It's also a good idea to add Network Library=DBMSSOCN; (with a
space between network and library) for OLEDB provider to make sure that the
provider will understand that it's a tcp/ip connection; for exemple:

oConn.Open "Provider=sqloledb;" & _
"Network Library=DBMSSOCN;" & _
"Data Source=xxx.xxx.xxx.xxx,1433;" & _
"Initial Catalog=myDatabaseName;" & _
"User ID=myUsername;" & _
"Password=myPassword"

http://support.microsoft.com/kb/q238949/

If the SQL-Server is not the default instance but a named instance, then you
must add the name of the instance after the address of the server (but
before the port number). Finally, you can take a look at the following
articles to help you troubleshooting connection problem:

http://www.datamasker.com/SSE2005_NetworkCfg.htm

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

http://msdn2.microsoft.com/en-us/library/ms345318.aspx

Using a remote desktop/terminal service is another way of accessing your
work. With TS, you will have the same configuration problem with your
router (excerpt that the port number is different) but with the advantage of
a better result in many situations (see below); however, it's not supported
on W2K Pro (you must have a server to use TS, not a workstation). (You can
have one remote session on WinXP Pro but the user must be there to accept
the incoming connection; so it's probably of no use in your situation;
however, I might be wrong on this.)

Probably that the speed of accessing your remote database over the internet
will not blast you away. If the system is too slow, then you will have to
use TS or to optimize your frontend/backend or to use another technologie
like .NET or ASP.NET. (TS is by far the easiest way but it will cost you
some $ because you must buy Win2003 Server.) However, many of my clients
are using ADP directly over the internet without to much problem of speed.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Bruce Maston" <homebrew@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:14AF3098-4A55-4E3C-BDA5-D48F3813DFAB@xxxxxxxxxxxxxxxx
I want to create my own SQL Server 2005 Express backend server with Access
as
the front end.

I have a three computer network behind a firewall router. Two machines
are
XP pro with the Access front end, and I added a third machine that is W2K
pro
with the SQL Server back end. I've upsized my tables, and I've got this
network working.

My next problem is to be able to connect to the SQL server inside my
network
from another computer at home with the same Access on it as the front end,
and this is where I am stumped.

I perceive that I need to do "something" to the SSMS and/or to the router
to
allow the connection, and I suspect that I need some sort of other
downloaded
MS piece of software or tool to enable this. Finally, I do not exactly
know
what the IP address is for a computer "inside" my network. (I have a
fixed
IP address for the network.) I've tried the IP address followed my the
computer's name in the network, the computers local address, etc. I've
used
colon separators, back slashes, commas, etc. All no go.

I see things like "remote desk top" and "terminal services," but I'm not
sure which one I might need (if that one or some other).

I'm sure that there must be other threads addressing this problem, but I
haven't been able to locate one.

Thank you.

.

Relevant Pages

  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)
  • RE: Small network with lots of features, questions
    ... Your network sounds overly complicated to me. ... to get to the internet. ... To do that, without using your server as a router, you need ...
    (microsoft.public.windows.server.networking)
  • Re: SBS 2008 Server losing DNS and Router Settings since Windows U
    ... backup plan you would have to figure out when the server got hacked then ... only thing that does mess with the router is Windows. ... if the NIC is not connected to the network (which there is ... On reflection I think I may have triggered the changes to DNS DHCP. ...
    (microsoft.public.windows.server.sbs)
  • Re: Still cant connect to RWW or OWA remotely
    ... laptop plugged into port on DSL router. ... service, e-mail, and RWW is available to all users on the network. ... The server is a SBS2003 SP1 Standard box without ISA, ... of the two NICs by clicking the Advanced tabs, it won't open that box, ...
    (microsoft.public.windows.server.sbs)
  • Re: Firewall and ISA
    ... Linksys uses NAT to protect you, claiming it's a firewall, but NAT is ... Full access to the network for maintenance, remotely, over a VPN, so ... dedicated server (meaning that ISA is not certified on a non-dedicated ... Are you saying that in addition to the ISA i need to get a new router? ...
    (microsoft.public.windows.server.sbs)
Loading