Documentation Center

Database Troubleshooting Tools

Standalone database tools can provide a wide range of information useful for troubleshooting. In particular, the following tools may be of assistance for SQL Server troubleshooting:
  • Enterprise Manger
  • Query Analyzer
  • SQL Profiler
These tools may be helpful for Oracle troubleshooting:
  • Enterprise
  • SQL Plus
  • Traces

In each case, consult the documentation for each tool to learn how to use them effectively. Traces in particular may require the assistance of a database administrator.

Enabling WorldServer to Connect to SQL Server
After you install SQL Server and create a database, you must also enable the SQL Server Browser and ensure that it is running. If SQL Server Browser is not enabled and running, WorldServer cannot connect through the TCP/IP protocol and fails with an error 500 (database instance nonexistent or not active).