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.

Required

  • Event Log
  • IIS Admin Service
  • License Logging Service
  • MSDTC
  • Protected Storage
  • Remote Procedure Call (RPC) Service
  • Server
  • Windows NT Server or Windows NT Workstation
  • Windows NTLM Security Support Provider
  • Workstation
World Wide Web Publishing Service

May Be Required

  • Certificate Authority (required to issue certificates)
  • Content Index (required if using Index Server)
  • FTP Publishing Service (required if using FTP service; it's highly recommended that FTP and Web services run on different servers)
  • NNTP Service (required if using NNTP Service)
  • Plug and Play (recommended, but not required)
  • Remote Access Services (required if you use dial-up access)
  • RPC Locator (required if doing remote administration)
  • Server Service (can be disabled, but required to run User Manager)
  • SMTP Service (required if using SMTP Service)
  • Telephony Service (required if access is by dial-up connection)
  • Uninterruptible Power Supply (UPS) (optional; but it is recommended that you use a UPS)
Workstation (optional; important if you have UNC virtual roots)
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

Popular posts from this blog

Backup & Restore Database as SQL Dump by SqlYog

Postfix can support per-domain outgoing IP addresses, but is not currently configured to do so

Wanna-cry-ransomware