ServerTools

IMPORTANT:  These sophisticated tools were designed to help Customer Support personnel efficiently resolve certain system problems that, although rare, would be time-consuming to fix otherwise.

Note: Although running these tools causes no harm to your system, there is no advantage to doing so unless you have one of the problems that the tools are designed to fix.

• Start Microsoft SQL Server Profiler. You use the SQL Server Profiler to monitor the effect of changes to your database on your SQL Server instance.

  Note: To take advantage of this feature, you should be familiar with SQL Server Profiler concepts and tasks.

• Remove orphaned file shares. Every company has a folder on the server that provides access from workstations to external files, such as file attachments, that are associated with the company.

  If a file share is not removed automatically when you delete a company—for example, if you deleted a database using SQL Server Management Studio and did not remove the corresponding file share manually—you could remove it using this tool. (Note that we strongly recommend that you only ever use Database Administration to delete companies.)

• Remove orphaned nightly maintenance tasks. If the scheduled maintenance task for a company is not removed automatically from Windows Task Scheduler when you delete the company, this tool can remove the task.

  Note: We strongly recommend that you only ever use Sage 100 Contractor  Database Administrationto delete companies!

• Reapply file permissions. Sage 100 Contractor maintains a system for managing access to data, and assigns security settings to each folder when the folder is created. Changing these security settings can have a detrimental effect on the normal operation of the software. This function reassigns the original security settings to each

  folder in the Sage 100 Contractor system.

• Reapply firewall rules. Selecting the Enable other machines to connect to this SQL server instance, in Advanced Settings, creates the firewall rules required for workstations to connect to the server.

  However, if the rules are later deleted in the firewall software, this tool reinstates them. For example, Windows 10 might have altered the firewall rules during an upgrade from an earlier version of Windows, or another user may have changed the firewall rules without realizing the implications for Sage 100 Contractor.

• Move default ‘tempdb’ to Sage 100 Contractor's preferred location. SQL Server uses the tempdb directory to hold temporary objects required for processing, and is recreated each time you start SQL Server.

  The first time you run Sage 100 Contractor Database Administration, it moves the tempdb location to the \Sage100Con\Company directory. This is the preferred location because:

  • The program sets the directory permissions correctly.
  • You can select a drive that has sufficient space and performance characteristics during setup.

  IMPORTANT:  You cannot delete this directory while the tempdb MDF and LDF files are stored here. Do not attempt to stop the SQL Server service, and then delete the directory. You will not be able to restart the SQL Server service because the tempdb location will be invalid.

• Move default ‘tempdb’ to SQL Server's default location. When you create the SQL Server instance, the tempdb is created automatically in the SQL Server default location (typically C:\Program Files\Microsoft SQL Server\MSSQL12.SAGE100CON\MSSQL\DATA). However, this location is not optimal because:

  • The C:\ drive may have limited space, and the tempdb is likely to grow, which can cause operational problems. For example, if a query requires more tempdb space than can be allocated, the query will fail.
  • The C:\ drive may be slow.
  • The permissions to the C:\drive may be very restricted.

  Although it is not optimal, you can relocate the tempdb location if you need to delete the directory at the Sage 100 Contractor preferred location.