Microsoft KB Archive/240715

= How to Install SQL 7.0 Desktop Edition on SBS 4.5 Clients =

Article ID: 240715

Article Last Modified on 11/19/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition, when used with:
 * Microsoft BackOffice Small Business Server 4.5
 * Microsoft SQL Server 7.0 Desktop Edition

-



This article was previously published under Q240715



SUMMARY
You can install SQL Server 7.0, Desktop Edition, on Small Business Server (SBS) 4.5 clients by using Setupsql.exe directly from the SBS 4.5 CD-ROM number 2, from a command prompt, or from a mapped drive. NOTE: Before installing this release of SQL Server 7.0, you should review the "Getting Started" and "Installing SQL Server" sections from SQL Server Books Online. You can run SQL Server Books Online directly from the CD-ROM. On SBS CD-ROM number 2, double-click the SQL70\x86\books\sqlbol.chm file.

To Start SQL Setup Directly from the CD-ROM

 * 1) On the client computer, insert SBS CD-ROM number 2 in the CD-ROM or DVD-ROM drive.
 * 2) Double-click the Setupsql.exe file in the SQL70\x86\Setup folder on SBS CD-ROM 2.
 * 3) Select the components you want to install.
 * 4) Click Next or OK until you finish the wizard, and then click Finish.

To Start SQL Setup from a Command Prompt
 On the client computer, insert SBS CD-ROM number 2 in the CD-ROM or DVD-ROM drive. At a command prompt, change to the SQL70\x86\Setup folder on SBS CD-ROM 2. Type the following command:

setupsql.exe k=Dk

NOTE: When you run SQL Server 7.0 Setup from a command line, do not use a Universal Naming Convention (UNC) file path (such as:

\\ \Public\SQL70\x86\Setup\Setupsql.exe k=Dk



To Start SQL Setup from a Mapped Drive Letter
 Map a drive letter to the appropriate folder on the SBS 4.5 CD-ROM number 2. Run the Setup program using the drive letter. For example



where  is the drive letter mapped to the \SQL70\x86\Setup folder on the CD-ROM.

It is best if you can switch to the folder on the CD-ROM or the drive letter first before issuing the command.

<div class="moreinformation_section">

MORE INFORMATION
Using these methods allows the Desktop version of SQL Server 7.0 and the Client utilities, Management tools, and Database Connectivity components to be listed on the Setup menu. NOTE: SQL Server 7.0 Books Online states that the Desktop Edition does not support read-ahead scans, merge joins, or hash joins. The Desktop Edition of SQL 7.0 does support these features.

Additional query words: SBSSQLFAQ SBS4.5 SQL7.0 Desktop MSDE smallbiz ISQL SQLEXEC ODBC OLEDB Net-Lib

Keywords: kbhowto KB240715

-

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

© Microsoft Corporation. All rights reserved.