Microsoft KB Archive/298932

= SMS: &quot;Connection Test Failed&quot; Error Message During SMS Web Reports Installation =

Article ID: 298932

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Systems Management Server 2.0 Standard Edition

-



This article was previously published under Q298932



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: kbbug kberrmsg kbprb kbsetup KB298932

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.