Solution Properties
Solution ID:
225924350085851
Last Modified Date:
Mon Apr 15 15:41:03 UTC 2024
Taxonomy Path:
Category//Data//Data management
Author:
legacyauthor
How to remove an old inactive SQL Server from the SQL Server name pick list in Database Administration for Sage 100 Contractor
Description

Inactive SQL Server names (instances) are displayed when connecting to Database Administration for Sage 100 Contractor or to company databases

Cause
Resolution
If the SQL Server instances are no longer active and have been disabled or uninstalled, you can remove them from the startup configuration file so they no longer appear on the SQL Server name picklist when connecting to Database Administration for Sage 100 Contractor, or the Sage 100 Contractor application.
 

Workstations (Sage 100 Contractor)

The following steps need to be performed on each workstation that is displaying an inactive SQL Server name:

  1. Close Sage 100 Contractor
  2. On the server, click the Windows Start button, and in the Search box type %localappdata% (this is a hidden file, so you must have the option to show hidden files enabled in Windows File Explorer)
  3. Locate and open the Sage folder, then open the Sage 100 Contractor SQL folder
  4. Locate the file Sage100Contractor.user.config, right-click on it and select Open With - open with Notepad
  5. Locate the section of text towards the bottom that lists, etc
  6. Delete the name of the inactive server from the PreviousServer# line(s) it appears in
  7. Save the file and close it
  8. Open Sage 100 Contractor and click the dropdown for the SQL server name - the inactive SQL server should no longer be listed

Server (Database Administration)

  1. Ensure you are logged into the server with the same account that was logged in when the SQL instance for Sage was installed
  2. Close Database Administration
  3. On the workstation, click the Windows Start button, and in the Search box type %localappdata% (this is a hidden file, so you must have the option to show hidden files enabled in Windows File Explorer)
  4. Locate and open the Sage folder, then open the Sage 100 Contractor SQL folder
  5. Locate the file DatabaseAdministration.user.config, right-click on it and select Open With - open with Notepad
  6. Locate the section of text towards the bottom that lists, etc
  7. Delete the name of the inactive server from the PreviousServer# line(s) it appears in
  8. Save the file and close it
  9. Open Database Administration and click the dropdown for the SQL server name - the inactive SQL server should no longer be listed.
[BCB:154:Chat 100 Contractor US:ECB]




 

Steps to duplicate
Related Solutions