Datasheet

HTTP endpoints
HTTP access to SQL Server 2005 is a new feature that allows programmers to
access SQL Server without depending on an IIS server running on the same
machine. SQL Server can coexist with IIS but unlike with SQL Server 2000, IIS
is no longer required for SQL Server 2005. HTTP endpoints allow developers
to use XML Web services with SQL Server 2005. The HTTP endpoint can exe-
cute T-SQL batch statements or stored procedures.
For security reasons, HTTP endpoints are disabled by default. To use HTTP
endpoints you need to specify which users, stored procedures, and data-
bases are enabled to support it.
Manageability Enhancements
The management tools in SQL Server 2005 have changed greatly from SQL
Server 2000. The main change is the arrival of SQL Server Management
Studio, which I describe in more detail in Chapter 3.
New management tools
SQL Server 2005 has new management tools. SQL Server Management Studio
replaces Enterprise Manager and Query Analyzer that you may be familiar
with from SQL Server 2000. SQL Server Management Studio also allows you to
manage Analysis Services instances and, therefore, also replaces Analysis
Manager.
SQL Server Management Studio allows you to manage multiple SQL Server
instances more easily. From one interface you can manage multiple instances
of the SQL Server database engine, Analysis Services, Integration Services,
and Reporting Services. I describe SQL Server Management Studio in detail in
Chapter 3.
SQL Server Configuration Manager is a new tool that allows you to control
services associated with SQL Server 2005. SQL Server Configuration Manager
replaces Service Manager and the server and client networking tools. You can
use SQL Server Configuration Manager to control the following:
⻬ SQL Server
⻬ SQL Agent
⻬ SQL Server Analysis Services
26
Part I: SQL Server 2005: An Overview
06_577557 ch02.qxp 12/20/05 9:43 PM Page 26