Re: SQL 2000 and MSDE/Express/Compact edition..

1) yes. Consider something like OpenVPN or using WebSynchronization with SQL Server 2005.
2) This is not my understanding. I know you can do silent installs to remote clients of SQL Server 2000, but I am not sure about MSDE. You will need to create an iss file for this. I have created installation packages for SQL Server 2005 Express that does complete configuration.
3) You need to use the encrypted file system to totally encrypt the contents of the laptop.
4) Yes. I would definately move to 2005 from end to end. We use SQL Server Express as opposed to CE.


"gstar" <gary.brett@xxxxxxxxx> wrote in message news:c497bc6b-5974-45f8-b661-904d30dcff6f@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have a SQL 2000 database on our server and intend to roll out a
desktop app with MSDE 2000 backend to 300 clients enabling them to
work offline then sync with our SQL server.

I have set this up in a demo environment and it appears to work OK as
long as MSDE subscriber is on the same LAN or connected via VPN, which
isnt going to be possible with 300 external clients.. Its also failry
cumbersome to install and I am unsure if I can even create an MSI
which will install it, setup security login to be used as agent and
replicate [being as it wouldnt be connected to SQL server at the
clients office]..

I have been doing further testing with this and lots of questions are
popping up, I wonder if anyone can help?

1 - The remote clients will not be connected to the main SQL via VPN,
do I have to leave a port open for SQL from WAN to LAN for
replication? If so I dont like the look of this?

2 - As I understand MSDE2000 can only be installed by local admin and
msi installs default instance. If this is true it appears I will need
to visit every client to configure their machines, add local sqladmin
accounts etc... seems harsh..

3 - Our database will be stored locally on a user laptop, MSDE offers
no method to lockdown so we could be in big trouble should the laptop
go missing? Again seems an oversight..

4 - Has anyone used 2005 express or better still 2005 compact edition?
These both seem to offer better local security and the compact version
can be rolled out at 2mb. Would appreciate any opinions as I will need
to upgrade the production server to 2005 also if this method is indeed
the best route..

Thanx

G

.

Relevant Pages

  • Re: 1 server 2 SQL apps
    ... Does it make sense in this situation to use MSDE 2000 SP3, ... MSDE has a limitation of 2 GB per database as well as you will not get the ... clients lke query analyzer, Enterprise manager. ... Best option for you might be, Install a default installation of SQL server ...
    (microsoft.public.sqlserver.server)
  • Detecting SQL Server VB6 (specifically)
    ... The "fat" part of the application installs several tools to ... Right now, when I build the system, I manually install MSDE, the web portion ... detect a running SQL server, ...
    (microsoft.public.vb.enterprise)
  • Re: MSDE Install For 98/SE/ME
    ... > I understand for Win 2k and XP installs that a simple re-boot after MSDE ... Andrea Montanari (Microsoft MVP - SQL Server) ...
    (microsoft.public.sqlserver.msde)
  • Re: I am getting incorrect responses to complicated Count() Query...
    ... I would LOVE to keep ACCESS/JET, but we have hundreds of clients and all too ... I love the fact that deploying JET is free as would MSDE be free. ... > suggest you use MS SQL Server Developer version, rather than MSDE, because ...
    (microsoft.public.access.queries)
  • Re: 1 server 2 SQL apps
    ... of your databases, but even a single processor machine with 1GB of RAM ... Regarding which to go with (MSDE or SQL Server). ... > The first application will run up to 10 clients with very low ...
    (microsoft.public.sqlserver.server)
Loading