Although Update Server is not designed to be run as a service, we understand there are advantages in having Update Server run as a service; especially in schools that experience frequent power outages. The information below is provided as a courtesy to schools in the hope it may be useful, but is not supported by Quick Vic Reporting. Different computers may have to use different registry keys or different drive paths.
There are a couple of articles from Microsoft describing how to convert any program to run as a service under Windows. These apply to Windows Server and also Windows Professional. ie there is no need to run Update Server on a server, a workstation will do fine.
The first article explains how to use any program as a service.
The second article explains why Visual Basic programs shouldn't be run as a service.
Internally, we have tried running UpdateServer as a service and all seems fine. We have also had reports back from many schools that they have successfully done the same. As far as Microsoft's recommendation goes regarding not using Visual Basic programs as services, we can see their point. However, UpdateServer is a quite stable program and if you test it and all is OK, we see no reason not to use it.
The following steps were submitted to us by one of our schools:
- Obtain latest srvany.exe and instsrv.exe from Microsoft Download site.
Ours came as parts of the latest free download of Windows 2003 Server Resource Kit Tools. The dates & sizes were:
18/04/2003 05:05 PM 32,256 instsrv.exe
18/04/2003 05:06 PM 8,192 srvany.exe
- Go to the server and copy these files to a "temp" folder.
- Go into the command line in this folder (eg "d:\temp")
- instsrv QVUpdate "d:\temp\srvany.exe"
Note that the full path name to the srvany.exe file must be specified.
- Run Regedit
- Navigate to HKLM\SYSTEM\ControlSet001\Services\QVUpdate
- Create a key called "Parameters" (without the quotes). Click in the "Parameters" key and create a new String Value called "Application" (no quotes). Change the value of the "Application" field to the program plus its parameters - ie:
- Go to services in Control Panel and set the startup options for the QVUpdate service (ie. User ID, password, start automatically, etc).
- Start the service
- As a new database is created each semester, the parameters in step 7 will need to be updated each semester with the new database path/name
"C:\Program Files\Quick Vic Reporting\UpdateServer.exe /Q=Y /D=C:\Example\Database.mdb" (without quotes)