Deploying Value-Added Business Solutions with Microsoft SQL Server 7.0 and MSDE 1.0

Microsoft Corporation
November 1999

Summary: This document is included with the Microsoft® SQL Server™ and Microsoft Data Engine (MSDE) Deployment Toolkit, and addresses design guidelines and technical strategies for automating the installation, configuration, and management of custom database applications. This comprehensive guide deploys value-added business solutions that leverage Microsoft SQL Server 7.0 or Microsoft MSDE 1.0 database services. (95 printed pages)

Contents

Introduction
SQL Server 7.0 Developer's Overview
     History of Microsoft SQL Server
     Scalable Database Platform
          SQL Server Standard, Developer, and Enterprise Editions
          SQL Server Desktop Edition
          SQL Server Small business Server Edition
          Microsoft Data Engine
     Database Server Architecture
          Client/Server Architecture
          Advanced Reliability and Concurrency Control
          Automatic Configuration and Tuning
          Automatic Disk Space Allocation
          Cost-Based Query Optimization
          Server-Enforced Data Integrity
     Integrated Database Services
          Database Management and Administration
          Distributed Database Services
          Decision-Support Services
     Application Development
          Application Programming Interfaces
          Query Language Support (Transact-SQL)
          Developing Multitiered Applications (Windows DNA)
          Developing Web Applications
     Microsoft BackOffice and Small Business Server Integration
          Windows NT Server Integration
          Exchange Server Integration
          SNA Server Integration
          Proxy Server Integration
          Site Server Integration
          Systems Management Server Integration
     Understanding SQL Server and MSDE Licensing
          SQL Server Licensing
          MSDE Licensing
Deploying Database Solutions
     Examining the System Prior to Installation
          Detecting Operating System Configuration Information
          Detecting Internet Explorer Configuration Information
          Detecting Database Server Configuration Information
     Automating Database Server Installation
          Determining Disk Space Requirements
          Database Server Installation Images
          Setup Initialization Files
          Running the Installation Executable in Unattended Mode
          Automating Database Server Service Pack Installation
          Database Upgrade Wizard
     Automating Application Database Installation
          Examining the Database Server Prior to Installation
          Automating Database Installation
     Automating Application Database Configuration
          Configuring Database Options
          Automating Security Configuration
     Automating Database Server Configuration and Administration
          Configuring Server Options
          Automating Database Maintenance
          Automating Service Configuration
          Configuring Other Database Services
     Automating Database Client Installation and Upgrades
          Internet Browser Clients
          Standard 2-Tier Clients
          N-Tier Clients
          Workstation-Based Database Server Installation
     Removing the Database Server
Acknowledgements
Appendix A: Feature Comparison of SQL Server 7.0 and MSDE 1.0
Appendix B: SQL Server 7.0 and MSDE 1.0 System Requirements
Appendix C: Application Database Design Guidelines
     Application Database Naming Guidelines
     Database Option Guidelines
     Code Page and Sort Order Guidelines
     Unicode Locale Id and Unicode Comparison Style Guidelines
     Security Guidelines
     Guidelines for Minimizing Administration
Appendix D: Setup-Related Files
Appendix E: Installation Executable Command-Line Parameters
Appendix F: Setup.Log ResultCode Values
Appendix G: Known Issues Related to Setup and Unattended Installations
     Windows 2000 Security Policies
     Unattended Upgrades Unsupported
     Unattended Remote Installations Unsupported
     Auto-Starting Database Services on Windows 95 and Windows 98
     SQL Server 7.0 Service Pack 1 Issues