Thursday, February 9, 2012

accessing MSDE over the internet

Hi!
I was wondering if it was possible to access a MSDE server through the
internet and if it is what settings have to be made on the server machine.
I would like this so I could make any required repairs of my application
over the internet...
Thanks,
sasoSaso,
The MSDE Database work fine if u have less than 15 concurrent users and the
Database maximum file is 1GB. You don't need do any special configuration to
MSDE work through internet, but the performance will be poor.
[ ]'s
PEDRO HENRIQUE NUNES - Brasil
"Saso Zagoranski" <saso.zagoranski@.guest.arnes.si> wrote in message
news:binqgk$fog$1@.planja.arnes.si...
> Hi!
> I was wondering if it was possible to access a MSDE server through the
> internet and if it is what settings have to be made on the server machine.
> I would like this so I could make any required repairs of my application
> over the internet...
> Thanks,
> saso
>|||let's say you are installing MSDE on your home PC. You give your IP address
to your friend and he can't connet to it. Here are things you should look
at:
1. your MSDE must use TCP/IP in net library.
2. you must know, and should change the default SQL port number 1433.
3. if you have a router you must have the router routes traffic on SQL port
to your MSDE box.
With a proper setup of your router and IP + port number given to your friend
he (she) can connect to SQL
"Saso Zagoranski" <saso.zagoranski@.guest.arnes.si> wrote in message
news:binuv2$iq8$1@.planja.arnes.si...
> I have MSDE installed on my computer and I gave my friend my IP address...
> and he cound't connect to my server...
> "Pedro Henrique" <pedro@.jew.com.br> wrote in message
> news:O9es1DkbDHA.3044@.TK2MSFTNGP11.phx.gbl...
> > Saso,
> >
> > The MSDE Database work fine if u have less than 15 concurrent users and
> the
> > Database maximum file is 1GB. You don't need do any special
configuration
> to
> > MSDE work through internet, but the performance will be poor.
> >
> > [ ]'s
> >
> > PEDRO HENRIQUE NUNES - Brasil
> >
> >
> >
> > "Saso Zagoranski" <saso.zagoranski@.guest.arnes.si> wrote in message
> > news:binqgk$fog$1@.planja.arnes.si...
> > > Hi!
> > > I was wondering if it was possible to access a MSDE server through the
> > > internet and if it is what settings have to be made on the server
> machine.
> > > I would like this so I could make any required repairs of my
application
> > > over the internet...
> > >
> > > Thanks,
> > > saso
> > >
> > >
> >
> >
>|||Hi Folks,
It also depends upon the version you have installed. At the SP3a level, MSDE
installs with network protocols disabled. Run the server network utility
SRVNETCN.exe to correct that.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Flicker" <hthan@.superioraccess.com> wrote in message
news:%23FaMV$kbDHA.2668@.TK2MSFTNGP09.phx.gbl...
> let's say you are installing MSDE on your home PC. You give your IP
address
> to your friend and he can't connet to it. Here are things you should look
> at:
> 1. your MSDE must use TCP/IP in net library.
> 2. you must know, and should change the default SQL port number 1433.
> 3. if you have a router you must have the router routes traffic on SQL
port
> to your MSDE box.
> With a proper setup of your router and IP + port number given to your
friend
> he (she) can connect to SQL
> "Saso Zagoranski" <saso.zagoranski@.guest.arnes.si> wrote in message
> news:binuv2$iq8$1@.planja.arnes.si...
> > I have MSDE installed on my computer and I gave my friend my IP
address...
> > and he cound't connect to my server...
> > "Pedro Henrique" <pedro@.jew.com.br> wrote in message
> > news:O9es1DkbDHA.3044@.TK2MSFTNGP11.phx.gbl...
> > > Saso,
> > >
> > > The MSDE Database work fine if u have less than 15 concurrent users
and
> > the
> > > Database maximum file is 1GB. You don't need do any special
> configuration
> > to
> > > MSDE work through internet, but the performance will be poor.
> > >
> > > [ ]'s
> > >
> > > PEDRO HENRIQUE NUNES - Brasil
> > >
> > >
> > >
> > > "Saso Zagoranski" <saso.zagoranski@.guest.arnes.si> wrote in message
> > > news:binqgk$fog$1@.planja.arnes.si...
> > > > Hi!
> > > > I was wondering if it was possible to access a MSDE server through
the
> > > > internet and if it is what settings have to be made on the server
> > machine.
> > > > I would like this so I could make any required repairs of my
> application
> > > > over the internet...
> > > >
> > > > Thanks,
> > > > saso
> > > >
> > > >
> > >
> > >
> >
> >
>

No comments:

Post a Comment