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 2005

After you install SQL Server 2005 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).

Tip: When you install SQL Server 2005, ensure that the SQL Server Browser is configured to start automatically as a service on server boot.