First make sure you’re running the database utility as an administrator. Right-click the shortcut and select Run as Administrator. If you’re still unable to open the database utility. Follow the steps listed below.
Step 1: Is the Engine Running?
- Right-click the Task Bar, select Start Task Manager, check the Processes tab for DBSRV17 (version 2019.1 or higher)
- If present, the Sybase Engine is running on the server but is no longer accepting requests, End the Task on DBSRV17
- If not present, find the server or workstation where the service is running and Stop then Disable the engine there. This usually means the server components were incorrectly installed onto a workstation
Step 2: Start the Service:
- Run the Service directly from the Service Manager application file:
- Open Windows Explorer and browse to the FASSVCMGR.exe file (Default location C:\SFAServ\COMMON). This location should be on the server.
- Right-click the FASSVCMGR.exe and select Run as administrator.
- Edit the -n parameter to be something other than the default engine name.
For Example:
Note: when changing the -n parameter, the only special charter allowed in the Underscore
Default service Parameters: -gp 4096 -ti 0 -tl 120 -gd all -n SFA_Engine
Change to: -gp 4096 -ti 0 -tl 120 -gd all -n SFA_Engine_New
Note: SFA_Engine_New is only an example, SFA_ would work also. - Click Save and click Start.
- Share the installation folder for the Sage Fixed Assets - Depreciation Network Server: Ensure the following: The SYSTEM account and Administrators have Full Control and Fixed Asset Users have at least Change\Read of the SFAServ share for both Sharing\Permissions and Security.
Step 3: Open the Database Utility - Network Depreciation & Tracking and Find the sample database.
- In the Registry of the system go to: HKEY_LOCAL_MACHINE\Software\wow6432node\Best Software\NWBESTSYS, Enter in the value of the -n parameter for the ENGINENAME.
- Go to: Start, Programs, Sage Fixed Assets, Tools, Right-click Database Utility - Network Depreciation & Tracking and select Run as Administrator.
- Click Find, Browse to where the databases are located (Default location C:\SFAServ\Data), click OK, click Search.
- Once found, highlight the FAS.db database, click Add and the database will disappear from the list of found databases.
- Once complete click Cancel to close the dialog.
Or if the database exists in the list before you changed the Engine Name:
- Highlight the databases listed one at a time, click Configure.
- Change the Engine Name to match the new -n parameter value.
Step 4: Open the Install.cfg (default location C:\SFAServ) to edit for the new Database Engine name if you had to change it after the installation completed.
NOTE: If you updated the -n parameter with a new Engine Name on the Production Server, also update the workstation's Registry. This ensures the new Engine Name is reflected for existing Sage Fixed Assets Network clients.
On each Sage Fixed Assets Network workstation:
- In the Registry of the system go to: Go to HKEY_LOCAL_MACHINE\Software\wow6432node\Best Software\NWBESTSYS
- Find ENGINENAME, right-click it and select “Modify…”, under Value data: type in the new Enginename used in Step 2, Sub 3 above.
[BCB:165:Chat Fixed Assets US:ECB]