Information About WEB SERVER IIS
For WEB SERVER IIS:
The following list outlines which
services are required, as well as those that are MAY be
required, to run Internet Information Server (IIS) on a secure
server. Your particular network or system configuration can
change some of the parameters. For example, some intranets
require WINS and DHCP.
|
For MS-SQL Database:
1.SQL Server
Display Name: SQL Server
(MSSQLSERVER)
Service Name: MSSQLSERVER
•SQL Server Windows Service: ◦This
is the primary database service and is used by the SQL Server
database engine.
◦There can be multiple instances of
SQL Server on a computer.
•This service is required (should be
running) to perform the following operations: ◦To query the data
from any of the databases present on the instance of SQL
Server.
◦For SQL Server Agent to
successfully perform the scheduled administrative tasks.
◦For proper functioning of SQL
Server Reporting Services (SSRS).
◦To view and manage the SSIS
packages (through SSMS) which are stored in msdb database.
•This service depends on the
following SQL Server related services: NONE
2.SQL Server Agent
Display Name: SQL Server Agent
(MSSQLSERVER)
Service Name: SQLSERVERAGENT
•SQL Server Agent Windows Service:
◦SQL Server Agent is the primary scheduling engine in SQL Server.
◦This is used to execute scheduled
administrative tasks like SSIS Packages, T-SQL Scripts, Batch Files,
Subscriptions etc. which are referred to as
Jobs. A Job is a parent level entity
which contains one or more steps. A step is the child/low level
entity which contains the actual
commands/instructions for performing a
specific task. Whereas a job defines the sequence of execution of
steps, schedule for running steps, etc.
◦Jobs can be executed in following
ways - on demand, on a schedule, or in response to a specific event.
◦It uses msdb database to store
the configuration, processing, and metadata information. Apart from
SQL Server Agent related information, msdb database
also stores similar information
related to other SQL Server features like Service Broker, Log
Shipping, SSIS Packages etc.
•This service is required (should be
running) to perform the following operations: ◦To perform the
scheduled administrative tasks like execution of SSIS
Packages, T-SQL Scripts, Replication,
etc.
◦For processing of report
subscriptions in reporting services.
•This service is not required (can
be in disabled state) to perform any of the following operations:
◦Querying the SQL Server Agent Job Information from the
msdb database.
◦For using other components like
SSIS, SSAS, SSRS etc. when they do not have any dependent tasks to
perform like executing SSIS Packages, processing
of cubes, processing of
subscriptions, etc.
•This service depends on the
following SQL Server related services: ◦[SQL Server (MSSQLSERVER)]:
SQL Server Agent stores all the metadata, configuration, and
processing information in a system
database called msdb. SQL Server service is required for the
functioning of SQL Server Agent.
◦[SQL Server Reporting Services]:
SQL Server Reporting Services window service should be running for
successful processing of scheduled reporting
services tasks like subscriptions
etc. which are performed by SQL Server Agent.
3.SQL Server Browser
Display Name: SQL Server Browser
Service Name: SQLBrowser
•SQL Server Browser Windows
Service: ◦This service acts as a listener for the incoming requests
for Microsoft SQL Server resources.
◦It provides information about the
list of installed SQL Server instances on the computer to the client
computers/applications.
◦Helps in browsing the list of
servers, locating and connecting to the correct server.
•This service is required (should be
running) to perform the following operations: ◦To connect to the
named instance of SQL Server if all the parameters like
TCP/IP port etc. are not provided.
◦To connect to the SQL Server
Analysis Services.
SQL Server VSS Writer
Display Name: SQL Server VSS Writer
Service Name: SQLWriter
•Highlights of SQL Server VSS Writer
Windows Service: ◦This service offers additional functionality for
backup and restoration operations in SQL Server by using
Volume Shadow Copy Service (VSS)
Framework.
◦A framework is implemented using a
set of COM APIs (VSS), which allows volume backups to be performed
while the data is being modified/written on to the disks.
•This service is required (should be
running) to perform the following operations: ◦To permit Windows
backup programs/software to copy the SQL Server data files while
SQL Server is running and the data is
being written to the disk.
Comments
Post a Comment