Gord, i clicked on the link. this documentation has been last updated in 2002. is it still relevant to use today on maxxi9 and the pervasvie.sql 9? am i meant to delete completely the pervasive.sql engine databse? there is an option that says "run all engines"and "stop all enginës" isnt it risky to do that? or i just follow the steps and do it on each and every computer?
ID: psql1828
Configure Workgroup or Workstation Engine to run as a Service under Windows NT, 2000, XP
Problem Description:
Configure Workgroup or Workstation Engine to run as a Service under Windows NT, 2000, XP
Problem Environment:
Pervasive.SQL 2000i WG
Pervasive.SQL 2000i WS
Service Pack 4
Microsoft Windows NT 4.0
Microsoft Windows 2000
Microsoft Windows XP
This enables the Workgroup or Workstation Engine to load automatically and to be available regardless of whether or not a user is logged in to the workstation. This procedure applies only to Pervasive.SQL 2000i SP4 or later.
Solution:
1. Remove the Workgroup/Workstation Engine from the Startup menu.
Click Start > Programs > Startup. Right-click on "Pervasive.SQL Workgroup Engine"
or "Pervasive.SQL Workstation Engine" then click Delete.
Ensure that you remove the Workgroup/Workstation Engine from all of the Startup
menus. For example, on Windows NT, check the Profiles Startup menu for All Users
as well as the profiles for other users.
2. Copy SRVANY.EXE and SRVINSTW.EXE to the subject computer's windows system
directory. For example, to "C:\WINNT\System32." These programs are included on the
Windows NT 4.0 Resource Kit CD. They may also be downloadable from Microsoft.
Install following either step 3 or step 4.
3. Install SRVANY.EXE as a service using the Service Creation Wizard.
a. Click Start -> Run.
b. Type "SRVINSTW.EXE" (without the quotes) in the Open box and click OK.
c. Select "Install a service" and click Next.
d. Select "Local Machine" and click Next.
e. Type in Pervasive.SQL 2000 Workgroup as the Service name and click Next.
NOTE: You may use any name you choose provided the name does not
contain any reserved characters like "\".
f. Enter the complete path to the SrvAny tool's executable, for example,
C:\WINNT\System32\srvany.exe and click Next.
g. Select "Service is its own process" and click Next.
h. Select "System Account".
i. Check "Allow Service to Interact with Desktop". If you prefer not to have the icon appear,
leave this box unchecked. Click Next.
j. Select "Automatic" and click Next.
k. Click Finish. The wizard should indicate that the service was successfully installed.
Click OK to clear the dialog.
4. Alternately to Step 3, install SRVANY.EXE as a service using INSTSRV.EXE.
Type the following at a command prompt:
instsrv "Pervasive.SQL 2000 Workgroup" c:\winnt\system32\srvany.exe
The completion message is "The service was successfully added!"
5. Open the Services dialog. (For example, on Window NT click Start > Settings > Control Panel,
then double-click Services.)
a. Click on the service you added in Step 3 or 4 (Pervasive.SQL 2000 Workgroup, for example).
b. Click Startup (for NT). For XP and Windows 2000, right-click, then click Properties.
c. Click (enable) the option Allow Service to Interact with Desktop. This option applies to
Log On As System Account.
d. Click OK.
e. Click Close.
Note: A valid user name and password are required to access
Pervasive.SQL databases on another machine. "System Account"
has no rights on other machines to Pervasive.SQL databases.
If you want the Pervasive Workgroup/Workstation service to
access databases on another machine, then you must specify a
valid user name and password for the other machine. For step 5c,
check the option This Account on the Log On As section and
specify a valid user name and password.
6. Use Regedit to configure SvrAny to execute the Workgroup/Workstation Engine by
adding a new key and values for that key.
WARNING: Using the Registry Editor incorrectly can cause serious, system-wide problems
that may require you to reinstall the operating system to correct them. Pervasive
Software does not guarantee that any problems resulting from the use of the
Registry Editor can be solved in any way other than by reinstalling the operating system.
Use this tool at your own risk!
a. Select the following registry key:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Pervasive.SQL 2000 Workgroup
NOTE: This example assumes that you named the service "Pervasive.SQL 2000 Workgroup."
If you chose a different name in Step 3 or 4, then the registry key will have that name
instead of "Pervasive.SQL 2000 Workgroup."
b. Add a new key named "Parameters"
c. Select the Parameters key just created.
d. Add a new REG_SZ value named "Application"
e. In the Data field for "Application" type in the complete path to the Engine's
executable (W3DBSMGR.EXE). If you performed a default installation of the
Pervasive.SQL 2000 Workgroup Engine, type in c:\pvsw\bin\w3dbsmgr.exe
f. Select the Parameters key created in Step 6b.
g. Add another new REG_SZ value named "AppParameters"
h. In the Data field for "AppParameters" type in -SRDE -SERVICE