Unable to connect to SQL server
Description
Cause
The server has TCP/IP and Named Pipes protocol disabled under SQL services.
This will cause the Configured System Database message to pop up and loop on the program launch.
Resolution

CAUTION:

The following steps include restarting the SQL server service hosting the Sage Fixed Assets Databases. If you have other databases hosted on the instance, the process will disconnect them temporarily.

 

  1. Log on to the server where you created the SQL server instance.
  2. Select Start, go to All ProgramsMicrosoft SQL Server 20xx, and select SQL Server 20xx Configuration Manager.
  3. On the left-hand pane, expand the SQL Server Network Configuration section.
  4. Select the SQL server instance where you're hosting the Fixed Assets databases.
  5. On the right-hand pane, check the status column of the protocols Named Pipes and TCP/IP.
  6. If you have any set to Disabled, right-click the row and select Enable.
  7. Verify the Status Column shows Enabled.
  8. On the left-hand pane, select the SQL Server Services section.
  9. On the right-hand pane, right-click on the SQL Server service instance you're hosting the Fixed Assets databases on. Click Restart.

 

[BCB:165:Chat Fixed Assets US:ECB]

 

 

Steps to duplicate
Related Solutions