Re: Access via internet?

I would use something more reliable than just opening a port in the
firewall, something like a VPN, that more secure than doing just a NATing.

--
HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---
"mikeb" <mike@xxxxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
news:e0HWDXrZFHA.464@xxxxxxxxxxxxxxxxxxxxxxx
> I'm not sure I follow.
>
> I have a PC app (actually a mobile PC app using Windows Mobile) that needs
> to access a database in another factory. I was thinking of opening the
> database to access via the internet (securely as possible) so that the app
> could access this remote database.
>
> I'm finding quite a few messages about people doing it, but I've still not
> found how.
>
> ?
>
> thx.
>
> "Jens Süßmeyer" <Jens@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote
> in message news:%23c4KRnmZFHA.1412@xxxxxxxxxxxxxxxxxxxxxxx
>>a static IP address at the host (thats when the SQL Server is reachable
>>over the internet in the DMZ) OR opening a port in the firewall, and use
>>of NAT? That´s when an option when your SQL Server is located in your LAN
>>and tunneled through NAT (and perhaps port translation). The sense of that
>>would be to use the Server for your internet application. But therefore
>>the last option would be preferable whereas a firewall would only allow
>>the Web Server (which could possibe host your application) to request
>>data.
>>
>> --
>> HTH, Jens Suessmeyer.
>>
>> ---
>> http://www.sqlserver2005.de
>> ---
>> "mikeb" <mike@xxxxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
>> news:eHI$yPmZFHA.1868@xxxxxxxxxxxxxxxxxxxxxxx
>>> Can someone point me to, if its possible, a means of allowing access to
>>> an MSDE database over the internet??
>>>
>>> I suspect it will involve a static IP address at the host, opening a
>>> port in the firewall, and use of NAT?
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: Connecting to an instance in a cluster
    ... "Geoff N. Hiten" wrote: ... you cannot reuse port numbers. ... Microsoft SQL Server MVP ... That is the port you have to open on the firewall. ...
    (microsoft.public.sqlserver.clustering)
  • Re: IIS, SQL 2000 & XPs Firewall
    ... Only one instance of SQL Server can use TCP port 1434. ... You may find it easier to use SQL Server Configuration Manager ... 2008 will be a named instance ... you will have to open those as exceptions in the firewall. ...
    (microsoft.public.sqlserver.connect)
  • Re: IIS, SQL 2000 & XPs Firewall
    ... You may find it easier to use SQL Server Configuration Manager ... 2008 will be a named instance ... Queries to the Data Engine must go to the port that SQL Server is ... you will have to open those as exceptions in the firewall. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Server 2008 remote connection problem
    ... Hitchhiker’s Guide to Visual Studio and SQL Server ... default instance of the SQL Server Database Engine listens on TCP port 1433", ... > I was trying to establish a remote connection to SQL Server 2008 from ... The server is running the XP firewall. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL server connection problem
    ... no firewall is installed? ... Also i have check that port 1433 is not ... Will SQL server only connect to this ... > to configure the firewall to permit connections to SQL Server. ...
    (comp.databases.ms-sqlserver)