How to Install SQL 7.0 Desktop Edition on SBS 4.5 Clients

• Microsoft SQL Server version 7.0, included with:
  • Microsoft BackOffice Small Business Server version 4.5
• Microsoft SQL Server, Desktop Edition, version 7.0

SUMMARY

You an 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

1. On the client computer, insert SBS CD-ROM number 2 in the CD-ROM or DVD-ROM drive.



2. At a command prompt, change to the SQL70\x86\Setup folder on SBS CD-ROM 2.



3. 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:

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

To Start SQL Setup from a Mapped Drive Letter

1. Map a drive letter to the appropriate folder on the SBS 4.5 CD-ROM number 2.



2. Run the Setup program using the drive letter. For example




drive:\SQL70\x86\Setup\Setupsql.exe k=Dk

where drive 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.

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 : SBS
Version : WINDOWS:7.0; winnt:4.5,7.0
Platform : WINDOWS winnt
Issue type : kbhowto