Microsoft KB Archive/314914

= Error Message: &quot;Microsoft Site Server Analysis Requires SQL Server ...&quot; =

Article ID: 314914

Article Last Modified on 2/6/2002

-

APPLIES TO


 * Microsoft Site Server 3.0 Standard Edition

-



This article was previously published under Q314914



SYMPTOMS
When you try to create or build an Analysis database or run Report Writer, you may receive one of the following errors:

Microsoft Site Server analysis does not currently support SQL server version 7.0.

Site Server Analysis requires SQL Server 6.50 Service Pack 4 plus SQL Server build 297 or greater. This installation is described in the Hardware and Software Requirements section of the Site Server 3.0 Readme.

Site Server Analysis requires either SQL Server 7.x or SQL Server 6.50 Service Pack 4 plus SQL Server build 297 or greater. This installation is described in the Hardware and Software Requirements section of the Site Server 3.0 Readme.



CAUSE
This behavior may occur if the files that are referred to in the &quot;Workaround&quot; section are not updated after you have applied the service pack.



RESOLUTION
To resolve this problem, obtain the latest service pack for Site Server 3.0. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

219292 How to Obtain the Latest Site Server 3.0 Service Pack



WORKAROUND
To work around this behavior, copy the following files manually:  Use one of the following steps:

 If you are running Site Server Service Pack 3 (SP3), extract the Sp3access.cab file for Microsoft Access or the Sp3sql.cab file for Microsoft SQL Server from the following location

\Microsoft Site Server\SP3\Setup

to the following location:

\Microsoft Site Server\Bin

 If you are running Site Server Service Pack 4 (SP4), extract the Spaccess.cab file for Access or the Spsql.cab file for SQL Server from the following location

\Microsoft Site Server\SP4\Setup

to the following location:

\Microsoft Site Server\Bin



The following five files are replaced in the \Microsoft Site Server\Bin folder:

 Dbsetup.exe Cimport.exe</li> Report.exe</li> Reportui.exe</li> Uimport.exe</li></ul> </li> Run the Analysis Database Setup Wizard, and then click the Update an existing database option as the Setup mode.</li></ol>

<div class="moreinformation_section">

MORE INFORMATION
The error message is displayed when you select to create an Analysis database by using the Update an existing database Setup mode on the SQL Server Login Direct tab.

Additional query words: MDAC Analysis SS3 SP3 SP4

Keywords: kbprb kbpending KB314914

-

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

© Microsoft Corporation. All rights reserved.