KnowledgeBase Archive

An Archive of Early Microsoft KnowledgeBase Articles

View on GitHub

Q298932: "Connection Test Failed" Error with SMS Web Reports Installation

Article: Q298932
Product(s): Microsoft Systems Management Server
Version(s): 2.0
Operating System(s): 
Keyword(s): kberrmsg kbsetup kbsms200 kbsms200bug smsinst
Last Modified: 28-AUG-2001

-------------------------------------------------------------------------------
The information in this article applies to:

- Microsoft Systems Management Server version 2.0 
-------------------------------------------------------------------------------

SYMPTOMS
========

When you try to install SMS Web Reports, you may receive the following error
message:

  Connection test failed! Please verify you have entered the connection
  information correctly.

CAUSE
=====

The SMS Web Reports require the use of standard security for the connection to
the SQL server. This error can occur if standard security is not enabled on the
SQL server. The following requirements must be met so you can install SMS Web
Reports:

- Installation requires Mixed or Standard SQL Security mode, and will not work
  with Integrated Security mode.

- When you install the SMS Web Reporting tool, you must type the password for
  the SA user account on the SQL server.

MORE INFORMATION
================

When you install SMS Web Reports, Setup must be able to grant READ access to the
SQL view objects. This requires the use of the SA account to obtain DBO rights
to the SQL view objects.

Additional query words: prodsms

======================================================================
Keywords          : kberrmsg kbsetup kbsms200 kbsms200bug smsinst 
Technology        : kbSMSSearch kbSMS200
Version           : :2.0
Issue type        : kbprb

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.