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)
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