INF: SQL Troubleshooters Available on the Web

ID: Q193088

The information in this article applies to:

Microsoft SQL Server versions 6.5, 7.0
Microsoft SQL Server, Enterprise Edition, versions 6.5, 7.0

SUMMARY

Troubleshooter Wizards that help you solve technical problems with Microsoft products are now available on the Microsoft Support Online Web site at http://support.microsoft.com/support/tshoot/default.asp. The following Troubleshooter Wizards are available for SQL Server:

SQL Server 7.0: Connectivity Troubleshooter

SQL Server 7.0: Distributed Query Troubleshooter

SQL Server 7.0: Data Transformation Services Troubleshooter

SQL Server 7.0: Full-Text Search Troubleshooter

SQL Server 7.0: Mail Troubleshooter

SQL Server 7.0: Query Performance Troubleshooter

SQL Server 7.0: Replication Troubleshooter

SQL Server 7.0: Setup Troubleshooter

SQL Server 6.5: Connectivity Error 10004 Troubleshooter

SQL Server 6.5: Installation and Connection Troubleshooter

SQL Server 6.5: Mail Troubleshooter

SQL Server 6.5: Error 1105 Troubleshooter

SQL Server 6.5: Slow Query Troubleshooter

SQL Server 6.5: Startup Troubleshooter

These troubleshooters are available at the following Web location:

http://support.microsoft.com/support/tshoot/default.asp

NOTE: If SQL Server is not listed in the drop-down list box on that page, click the List All Microsoft Products That Have a Troubleshooter link that appears just below the drop-down list box.

MORE INFORMATION

The remainder of this article provides descriptions of what is covered in each of the troubleshooters in the preceding list.

SQL Server 7.0: Connectivity Troubleshooter

This troubleshooter covers the following problems:

I can't connect from an ODBC application.

I can't connect through a firewall.

I can't connect. The specified SQL Server computer isn't found.

I can't establish a trusted connection.

I can't connect, and I receive a Login failed error message.

I can't register a new server in SQL Server Enterprise Manager.

SQL Server 7.0: Distributed Query Troubleshooter

This troubleshooter covers the following problems:

I have difficulty with distributed queries to an online analytical processing (OLAP) server.

I have difficulty with distributed queries to Oracle.

Distributed query performance is degraded.

I receive a specific error message from a distributed query, and I want more information about it.

I can't create or administer a linked server.

SQL Server 7.0: Data Transformation Services (DTS) Troubleshooter

This troubleshooter covers the following problems:

I'm having a problem using DTS Designer or a wizard to create a DTS package.

I'm having a problem executing a scheduled package.

I'm having a problem executing a package that isn't scheduled.

My DTS package takes a long time to complete.

My DTS package takes a long time to stop running after it fails or is canceled.

SQL Server 7.0: Full-Text Search Troubleshooter

This troubleshooter covers the following problems:

I have a problem using CONTAINS or FREETEXT.

I can't enable databases for full-text search or full-text catalog creation.

I have a problem with full-text indexing or populating full-text catalogs.

Full-text indexing or searching performance is poor.

SQL Server 7.0: Mail Troubleshooter

This troubleshooter covers the following problems:

SQL Mail won't start with Microsoft® Exchange Server.

SQL Mail causes exception error 35909.

SQL Mail won't send or receive messages.

SQL Mail won't start with a Microsoft® Mail post office.

The system stored procedure sp_processmail fails, but I don't receive an error message.

SQL Server 7.0: Query Performance Troubleshooter

This troubleshooter covers the following problems:

My SQL Server 7.0 application is slow.

A particular query is slow when it's run as a stored procedure, yet fast when it's run outside the procedure.

A large batch of small queries is slow.

My queries work great alone, but when several people are running queries at the same time the queries really slow down.

A particular query is slow.

SQL Server 7.0: Replication Troubleshooter

This troubleshooter covers the following problems:

I can't create a publication.

I can't transfer reference constraints to filtered subscriptions.

I'm having a problem with a Distribution Agent.

I'm having a problem with a Log Reader Agent.

I'm having a problem with a Merge Agent.

I'm having a problem with Replication Monitor.

SQL Server 7.0: Setup Troubleshooter

This troubleshooter covers the following problems:

SQL Server 7.0 Desktop Edition

SQL Server 7.0 Enterprise Edition

SQL Server 7.0 Standard Edition

SQL Server 6.5: Connectivity Error 10004 Troubleshooter

This troubleshooter covers the following problem:

I receive this connectivity error:

10004 Unable to connect: SQL Server is unavailable or does not exist.

SQL Server 6.5: Installation and Connection Troubleshooter

This troubleshooter covers the following problems:

I receive the following error message:

Connection failed - SQL State 01000/SQL Server Error 5 - Access denied.

I receive the following error message:

OS error:10061 connection refused.

I receive the following error message:

SCM3-1057. Installation couldn't be completed.

I receive the following error message:

SQL 2140: Internal Windows NT error occurred.

I receive one of the following error messages:

Could not start MSSQLServer Service on \\servername.

-or-

Error 1058: The specified service is disabled and cannot be started.

Installation almost completes or causes "non-critical" errors, but Setup doesn't generate any icons.

I receive the following error message:

Odbcint.dll is being used by another application. Installation could not be completed.

I receive the following error message:

SQL Executive could not be started

When I start SQL Executive, I receive Error 1069:

SQL Executive log on failure.

I receive the following error message:

Upgrade failed with a service specific error 1060 - service not installed.

SQL Server 6.5: Mail Troubleshooter

This troubleshooter covers the following problems:

SQLMail won't start with Microsoft Exchange Server.

SQLMail causes exception error 35909.

SQLMail won't send or receive messages.

SQLMail won't start with a Microsoft Mail post office.

The system stored procedure sp_processmail fails, but it does not display an error.

SQL Server 6.5: Error 1105 Troubleshooter

This troubleshooter covers the following problems:

I receive a run-time 1105 error when the object name is not Syslogs.

I receive a run-time 1105 error when the object name is Syslogs.

I receive an 1105 error during recovery on a user database.

I receive an 1105 error during recovery on the model database.

I receive an 1105 error during recovery on the master database.

SQL Server 6.5: Slow Query Troubleshooter

This troubleshooter covers the following problems:

My query used to run fast, but now it’s very slow.

The server seems slow overall; can I adjust something to increase server speed?

A particular query is slow.

My queries work great alone, but when several people are running queries at the same time the queries really slow down.

A particular query is slow when it's run as a stored procedure, yet fast when it's run outside the procedure.

INSERT and UPDATE statements take much longer to run than SELECT statements.

I want to improve performance; should I put tempdb in RAM?

SQL Server 6.5: Startup Troubleshooter

This troubleshooter covers the following problems:

The SQL Server error log contains operating system errors indicating that a device couldn't be found or opened.

SQL Server does not start, but there are no errors.

The error log contains the following error message:

crdb_tempdb: Unable to move tempdb into RAM.

I receive the following error message:

Unable to Locate DLL. The dynamic link library filename could not be found in the specified path.

Additional query words:

Keywords : SSrvISQL SSrvNet_Lib kbSQLServ650 kbSQLServ700
Version : winnt:6.5,7.0
Platform : winnt
Issue type : kbinfo