a question for setup experts please

hello,
i have sql server 2000 on my local machine (with enterprise manager etc).
i want to host a website (on a dedicated server) which talks to sql server,
but i dont want to buy another license for the server machine that i am
going to host on (too much money!).
my question is:
is there a way around this? ie: is there a free engine or something that i
can install on my webserver which just stores the datafiles so my webpages
will work.
ideally i would like to DTS data to and from the live server, and also use
my local enterprise manager to view/update data on the live server?
is this possible?
thanksDepending on your requirements, you could deploy MSDE.
Not sure what this has to do with alt.photography though...
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"tracy" <tracyy@.spamfreenyf.com> wrote in message
news:GX9Xb.7063$ul3.1002@.news-binary.blueyonder.co.uk...
> hello,
> i have sql server 2000 on my local machine (with enterprise manager etc).
> i want to host a website (on a dedicated server) which talks to sql
server,
> but i dont want to buy another license for the server machine that i am
> going to host on (too much money!).
> my question is:
> is there a way around this? ie: is there a free engine or something that
i
> can install on my webserver which just stores the datafiles so my webpages
> will work.
> ideally i would like to DTS data to and from the live server, and also use
> my local enterprise manager to view/update data on the live server?
> is this possible?
> thanks
>|||lol, yeah the alt.photography was a bit of a mistake!
Can you tell me more about MSDE please, and whether it will meet my
requirements mentioned below.
Thanks.
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:OANb4um8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> Depending on your requirements, you could deploy MSDE.
> Not sure what this has to do with alt.photography though...
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "tracy" <tracyy@.spamfreenyf.com> wrote in message
> news:GX9Xb.7063$ul3.1002@.news-binary.blueyonder.co.uk...
> > hello,
> >
> > i have sql server 2000 on my local machine (with enterprise manager
etc).
> >
> > i want to host a website (on a dedicated server) which talks to sql
> server,
> > but i dont want to buy another license for the server machine that i am
> > going to host on (too much money!).
> >
> > my question is:
> > is there a way around this? ie: is there a free engine or something
that
> i
> > can install on my webserver which just stores the datafiles so my
webpages
> > will work.
> >
> > ideally i would like to DTS data to and from the live server, and also
use
> > my local enterprise manager to view/update data on the live server?
> >
> > is this possible?
> >
> > thanks
> >
> >
>|||http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp
http://www.microsoft.com/sql/msde/
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"tracy" <tracyy@.spamfreenyf.com> wrote in message
news:r5aXb.7185$ul3.128@.news-binary.blueyonder.co.uk...
> lol, yeah the alt.photography was a bit of a mistake!
> Can you tell me more about MSDE please, and whether it will meet my
> requirements mentioned below.
> Thanks.
> "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> news:OANb4um8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> > Depending on your requirements, you could deploy MSDE.
> >
> > Not sure what this has to do with alt.photography though...
> >
> > --
> > Aaron Bertrand
> > SQL Server MVP
> > http://www.aspfaq.com/
> >
> >
> >
> >
> > "tracy" <tracyy@.spamfreenyf.com> wrote in message
> > news:GX9Xb.7063$ul3.1002@.news-binary.blueyonder.co.uk...
> > > hello,
> > >
> > > i have sql server 2000 on my local machine (with enterprise manager
> etc).
> > >
> > > i want to host a website (on a dedicated server) which talks to sql
> > server,
> > > but i dont want to buy another license for the server machine that i
am
> > > going to host on (too much money!).
> > >
> > > my question is:
> > > is there a way around this? ie: is there a free engine or something
> that
> > i
> > > can install on my webserver which just stores the datafiles so my
> webpages
> > > will work.
> > >
> > > ideally i would like to DTS data to and from the live server, and also
> use
> > > my local enterprise manager to view/update data on the live server?
> > >
> > > is this possible?
> > >
> > > thanks
> > >
> > >
> >
> >
>|||You could also post specific questions to *just*
microsoft.public.sqlserver.msde
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"tracy" <tracyy@.spamfreenyf.com> wrote in message
news:r5aXb.7185$ul3.128@.news-binary.blueyonder.co.uk...
> lol, yeah the alt.photography was a bit of a mistake!
> Can you tell me more about MSDE please, and whether it will meet my
> requirements mentioned below.
> Thanks.
> "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> news:OANb4um8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> > Depending on your requirements, you could deploy MSDE.
> >
> > Not sure what this has to do with alt.photography though...
> >
> > --
> > Aaron Bertrand
> > SQL Server MVP
> > http://www.aspfaq.com/
> >
> >
> >
> >
> > "tracy" <tracyy@.spamfreenyf.com> wrote in message
> > news:GX9Xb.7063$ul3.1002@.news-binary.blueyonder.co.uk...
> > > hello,
> > >
> > > i have sql server 2000 on my local machine (with enterprise manager
> etc).
> > >
> > > i want to host a website (on a dedicated server) which talks to sql
> > server,
> > > but i dont want to buy another license for the server machine that i
am
> > > going to host on (too much money!).
> > >
> > > my question is:
> > > is there a way around this? ie: is there a free engine or something
> that
> > i
> > > can install on my webserver which just stores the datafiles so my
> webpages
> > > will work.
> > >
> > > ideally i would like to DTS data to and from the live server, and also
> use
> > > my local enterprise manager to view/update data on the live server?
> > >
> > > is this possible?
> > >
> > > thanks
> > >
> > >
> >
> >
>