You need to mimic the steps a "person" sitting in front of the computer
would do, normally an SQL2k DBA would be doing these things.
So, get you an SQL2k DBA, and start from there - this will most likely take
several days to a couple of weeks to get correct.
You'll have to install SQL/MSDE (that will require admin rights).
Configure SQL/MSDE for your application.
Configure and start SQL/MSDE (that will required SYS DBA rights).
As far as users starting the application, they'll need "local" admin rights
on the box where SQL/MSDE is installed, they'll also most likely need SYS
DBA rights to start the appropriate database/related services.
--
Star Fleet Admiral Q @ your service!
"Google is your Friend!"
www.google.com
*************** *************** *************** **
"Olav" <Ol**@discussio ns.microsoft.co m> wrote in message
news:C2******** *************** ***********@mic rosoft.com...
Hi,
we are writing an installation routine for our app using .net framework
1.1. The inst routine has 2 parts: 1 for the server and one for the clients.
The database is MSDE for the small customers and MS SQL server for the big.
1: How can we automaticaly set up the clients so that they are permitted
to start the main program on the server?
2: How can the installation program set up an automatically sheduled
database maintenance with consistency check and recovery?
Regards,
Olav
