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).