Synopsis
SQL Server 7 Admin: Server Repair shows users how to troubleshoot problems with installation upgrading and access to servers.

Audience
This course is for database administrators who want to learn how to administer SQL Server 7.0 or who are preparing for the MCSE exam 70-028: Administering Microsoft SQL Server 7.0.

Time
4 hours

Product Code: LA7C18
After completing SQL Server 7 Admin: Server Repair the user should be able to:

Diagnose and resolve problems with upgrading from SQL Server 6.x
Use the Client Configuration utility to diagnose and resolve client connectivity problems
Diagnose and resolve problems regarding access to SQL Server databases and database objects

Overview of Troubleshooting
Preparing to troubleshoot
SQL Server startup parameters
SQL Server command-line utilities

Solving Installation Problems
Basic installation checklist
Planning for installation
Advanced installation problems

Solving Upgrading Problems
Upgrade overview
Output from the upgrade process

More About Upgrading Problems
Double-checking the upgrade prerequisites
Special upgrade considerations
Compatibility issues

Troubleshooting Server Access Problems
Network connectivity
NT Authentication
SQL Server Authentication

Troubleshooting SQL Server Permissions
Accessing databases
Shortcut to find a user's groups
Object access permissions

This course has the following features:

Exercises that allow users to practice in SQL Server 7.0
A file containing the text of the exercises
Simulations that allow users to practice course skills even if they don't have access to SQL Server 7.0
A glossary
A Skill Assessment

Courses on Relational Database Management Systems or equivalent experience
Courses on Windows NT administration or equivalent experience
Courses on Database Concepts or equivalent experience
Courses on SQL or equivalent experience
SQL Server 7 Admin: Security Strategy (LA7C01)
SQL Server 7 Admin: System Requirements (LA7C02)
SQL Server 7 Admin: Migration Planning (LA7C03)
SQL Server 7 Admin: Replication Plans (LA7C04)
SQL Server 7 Admin: Installing the Server (LA7C05)
SQL Server 7 Admin: Other Installations (LA7C06)
SQL Server 7 Admin: Configuring (LA7C07)
SQL Server 7 Admin: Security Management (LA7C08)
SQL Server 7 Admin: Managing Accounts (LA7C09)
SQL Server 7 Admin: Managing Permissions (LA7C10)
SQL Server 7 Admin: Database Management (LA7C11)
SQL Server 7 Admin: Loading Databases (LA7C12)
SQL Server 7 Admin: Backups and Restores (LA7C13)
SQL Server 7 Admin: Managing Replication (LA7C14)
SQL Server 7 Admin: Management Tasks (LA7C15)
SQL Server 7 Admin: Monitoring Events (LA7C16)
SQL Server 7 Admin: Watching & Optimizing (LA7C17)

SQL Server 7 Admin: More Troubleshooting (LA7C19)

Microsoft® is a registered trademark of Microsoft Corporation.