Re: MSDE automatic install

Thanks for pointing out that the Service Manager was installed on the
startup menu. I hadn't noticed this. But it has the auto-start box
unchecked, so that's one more thing the user would have to do manually that
I'd rather avoid. Is there a way to automatically change that setting? I'd
rather have it running at startup than start it in my app.

In reading some other newsgroup posts I found out about a command-line
program called scm.exe (Service Control Manager) but I can't get it do
anything except display its help screen. Do you know anything about this?

I will look into SQLDMO, it sounds very interesting. Actually my app is
written in Delphi but it is not a problem to use the API.

Glenn

<jcarper@xxxxxxxxxxx> wrote in message
news:1115067284.845627.140910@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi Glenn,
>
> The install already took care of installing the SQL Manager at Startup
> (look in your startup folder).
>
> Most of your management of the SQL Server can be done thru what is
> called the SQLDMO API. These two lines of VB\VBA code will start up
> your server.
>
> Set MySQLServer = CreateObject("SQLDMO.SQLServer")
> MySQLServer.Start True, "WINDOWS98SE", "sa", "sa"
>
> In the example above "WINDOWS98SE" is the NetBios name. If a custom
> instance was used the server name would have looked more like
> "WINDOWS98SE\MyInstanceName".
>
>
> Glenn Alcott wrote:
> > I'm the developer for a commercial application and we're planning to
> migrate
> > the database from Paradox to MSDE. I need to be able to completely
> automate
> > the install of MSDE on user's systems. As a test, I downloaded
> MSDE2000A.EXE
> > and installed it on a Windows 98 machine. The installation went fine
> and
> > that part seems simple. However, I also need it to be set up to run
> > automatically at system startup (as if "Auto-start service when OS
> starts"
> > had been checked in the Service Manager). How can I do that as part
> of my
> > installation?
> >
> > Glenn
>


.

Relevant Pages

  • Re: MSDE automatic install
    ... The install already took care of installing the SQL Manager at Startup ... Most of your management of the SQL Server can be done thru what is ...
    (microsoft.public.sqlserver.setup)
  • RE: SQL Server Service Manager Problem on SBS2003 Standard
    ... I believe I already have this update, as SQL ... Service Mgr is in my startup and always shows up in the system tray. ... problem is that the other program I am trying to install, ... This update will place the SQL Server Service Manager shortcut to launch at ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory usage
    ... and I've noticed that it tends to eat up some memory. ... manager before and i was using 31% after startup and after I open up a ... that stuff is also on after startup. ... A first step might be to install Process Explorer to ...
    (microsoft.public.windows.vista.general)
  • Re: Confession of IT nightmare employee
    ... Having a manager who is ... are afraid of the IT group. ... this password work in the script, but not for logon?". ... work desktop to install a piece of software. ...
    (microsoft.public.scripting.vbscript)
  • Re: Eventlog & WMI wont run, RPC is running
    ... I'd go for a clean install. ... Microsoft MVP [Windows] ... | DISPLAY_NAME: avast! ... Logical Disk Manager Administrative Service ...
    (microsoft.public.windowsxp.wmi)