Remote Access

[Jason Breeze]

Ben,
I'm also assuming you can connect via VPN to your router.

"Ben" <benross7@hotmail.com> wrote in message
news:96969a26.0307290717.2decda7a@posting.google.c om...

> I have a client who wants to log into FMP from home. The host (server)
> is also a client machine for the owner of the company. He hosts FMP
> and does his day to day stuff on this machine. Would the solution to
> my problem simply be just have the remote user log into the router
> (dynamic IP address, it would change everytime it restarts, or at
> least is my understanding) to get to the host machine, and login to
> FMP in that manner. Or are there issues since there is no static IP
> address? Would I be able to use DHCP in some manner?
>
> Yes, I've already recommended that boss purchase a server and stop
> using the server as a client machine. Tough times we live in.
>
> Also, I am not trying to put my FMP DB's on the web, but let me know
> if this is the only possible method to achieving success.
>
> Thanks,
>
> Ben

[paul]

Im having problems using remote access on XP workstations
to connect to a 2003 server. An error saying 'a
licencing server is not available'. The server has been
rebooted but the same error is still accuring. Any ideas?
Thanks.

[Jonathan Maltz [MS-MVP]]

Hi,

Do you have a separate TS licensing server in the domain?

--
--Jonathan Maltz [Microsoft MVP - Windows Server, Virtual PC]
[url]http://www.visualwin.com[/url] - A Windows Server 2003 visual, step-by-step
tutorial site :-)
[url]http://vpc.visualwin.com[/url] - Does <insert OS name> work on VPC 2004? Find out
here
Only reply by newsgroup. I do not do technical support via email. Any
emails I have not authorized are deleted before I see them.


"paul" <anonymous@discussions.microsoft.com> wrote in message
news:2675001c4613f$f1ab5d30$a301280a@phx.gbl...

> Im having problems using remote access on XP workstations
> to connect to a 2003 server. An error saying 'a
> licencing server is not available'. The server has been
> rebooted but the same error is still accuring. Any ideas?
> Thanks.

[Kristofer Gafvert]

Hello,

This happens when you accidently installs TS when you really want to use
Remote Desktop. TS requires a license server, while Remote Desktop do not
need one. If you are gonna use this for administrating the server, uninstall
TS, enable Remote Desktop, and it should be fine.

--
Regards,
Kristofer Gafvert - IIS MVP
[url]http://www.ilopia.com[/url] - When you need help!


"paul" <anonymous@discussions.microsoft.com> wrote in message
news:2675001c4613f$f1ab5d30$a301280a@phx.gbl...

> Im having problems using remote access on XP workstations
> to connect to a 2003 server. An error saying 'a
> licencing server is not available'. The server has been
> rebooted but the same error is still accuring. Any ideas?
> Thanks.

[soup_or_power@yahoo.com]

Hi
I have a mysql database instance running on a box that is behind a
fire-wall. I want to disable some users access to the database when
they are logging in from outside the firewall (internet). I know that
it is possible to deny access to static IP addresses at the firewall.
However, some of my users can have dynamic IP's (eg. modem). Is there
anyway to determine the IP address of the user and deny access if it is
not an intranet IP.

Thanks for your help.

[Bill Karwin]

[email]soup_or_power@yahoo.com[/email] wrote:

> anyway to determine the IP address of the user and deny access if it is
> not an intranet IP.

I would use the GRANT statement to give these users access only when
connecting from the intranet. For example:

GRANT ALL PRIVILEGES ON databasename.* TO 'username'@'192.168.0.%'
IDENTIFIED BY 'password';

Assuming that your intranet subnet is on 192.168.0, from the perspective
of the MySQL server host.

You should REVOKE any other privileges the user has before doing this,
or else both sets of privileges will be in effect and the more
permissive one will allow them in.

Regards,
Bill K.

[Gordon Burditt]

>I have a mysql database instance running on a box that is behind a

>fire-wall. I want to disable some users access to the database when
>they are logging in from outside the firewall (internet). I know that
>it is possible to deny access to static IP addresses at the firewall.

With a decent firewall at your Internet gateway, you should be able
to deny direct access to the database:

- *ANY* connections coming from outside to port 3306.
- Connections coming from outside to port 3306 from any but a short
list of known-permitted netblocks.

This does not, however, prevent them from logging in to a host in
your intranet via telnet or ssh, then accessing the database from
there. To block that you probably block any telnet or ssh connection
from outside.

Using the MySQL permissions system, using GRANT you should be able to allow
access only from specific netblocks for specific users.

If you are talking about accessing the database *THROUGH A WEB SITE*,
unless you cut off the database from the web site entirely, you need
to enforce the limits at the web site. There are a number of
ways to do this:

- Apache .htaccess files
- Using $REMOTE_ADDR in CGI programs.
- Using $_SERVER['REMOTE_ADDR'] in PHP.

>However, some of my users can have dynamic IP's (eg. modem). Is there
>anyway to determine the IP address of the user and deny access if it is
>not an intranet IP.

Use a white list, not a black list here. You probably know which IPs
in your intranet are dialups (you probably don't have your own dialups
at all, they belong to your ISP or some other ISP).

Gordon L. Burditt