MSDE + Static IP Address ?

Hello, could someone please tell me if the following scenario would work with MSDE:
1) A central computer with a static IP address exposed to the internet would be used to store a small database.
2) A couple of computers located around the country would access this database through the internet. THe client they would use would be in EXE form, ( a custom built application) , which would use the Static IP as the database server name. Basically eac
h locatoin would have their own software install, and instead of comunicating on their local LAN to the db-server, they would use the static IP to connect to the remote database.
Would the above work? or is there a special requirement for the above that i've missed?
Thanks.
Hi,
You can connect MSDE to the internet and the remote apps should be able to
talk to the MSDE.
just make sure that you enable the required Protocols for the SQL Server
and make sure that the port is available.
Configure Firewall etc.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi, Thanks for the info,
So basically i just configure the internet protocols, and use the IP as my database server "Setting" in my client-exe along with the database name... wow that would be cool.

>Hi,

>You can connect MSDE to the internet and the remote apps should be able to
>talk to the MSDE.

>just make sure that you enable the required Protocols for the SQL Server
>and make sure that the port is available.

>Configure Firewall etc.
|||Hi,
In addition, we sometimes find increasing the connection timeout in the
connectionstring of your application might be necessary in this scenario.
Otherwise, works ok.
I'd strongly suggest moving the MSDE to a high non-standard port (ie 47857)
instead of 1433 and employing some form of port-sniffing detection on the
system it's running on, if it's directly connected.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"SQL-Warrior" <anonymous@.discussions.microsoft.com> wrote in message
news:9FBD8FAA-1080-482A-B55A-4411792F3AFF@.microsoft.com...
> Hi, Thanks for the info,
> So basically i just configure the internet protocols, and use the IP as my
database server "Setting" in my client-exe along with the database name...
wow that would be cool.[vbcol=seagreen]
>
to
>
>
|||Ok, thanks for the info,
i can't wait to try it out.
|||I forgot to ask, is there any special setup required on the server? Or is it one of those install MSDE and make sure the machine has a static IP and is connected to the internet installs?
|||You need to make sure the network protocols are enabled. You can do this
after installation (and applying any patches, etc.) by running svrnetcn.exe
(ie the server network utility). Use it to both enable tcp and to set it to
a different port.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"SQL-Warrior" <anonymous@.discussions.microsoft.com> wrote in message
news:D74B7469-B7EF-4EBC-9955-082183E9B464@.microsoft.com...
> I forgot to ask, is there any special setup required on the server? Or is
it one of those install MSDE and make sure the machine has a static IP and
is connected to the internet installs?
|||Ahhh, ok thanks !
this is soo cool.
sql