Provides storage,processing, and controlled access of relational data and rapid transactionprocessing. SQL Server Components and Service Descriptions Table 3-1 Describes SQL Server components and their corresponding services. These services are typically installed along with the main services and you do not need to install them explicitly. In addition, there are auxiliary services that are not exposed to client applications but support other services such as SQL Server Active Directory Helper and SQL Server VSS Writer. For example, SQL Server Browser service, which provides instance name resolution for all instances, is not associated with a particular instance. There are also services that are shared between all instances on a computer. For example, Integration Services is not associated with any instances of SQL Server and it can only be installed once on a computer. You should also know that not all SQL Server components can be installed in multiple instances on the same computer. End-user applications can connect to any of these components in the Accounting or Sales instances the same way they would connect to these components if they were installed on two separate computers. For example, on a given computer that has two SQL Server instances named Accounting and Sales, the Accounting instance may have a Database Engine and a Reporting Services component, and the Sales instance may have a Database Engine and an Analysis Services component. Each instance of SQL Server consists of a number of components, and each component has a separate set of services. But before we describe how you can perform this sort of tasks, you need to understand the relationship between SQL Server instances, components and services.Īs described in Chapter 2, SQL Server allows multiple instances of SQL Server to run simultaneously on the same computer. You may also need to find out the physical association of components and instances, and the state of services for each of the installed components. Whether it is your initial configuration or part of your daily administration of SQL Server, you will encounter situations where you need to identify instances of SQL Server that are installed on a given computer. Identifying SQL Server Instances and Components on a Computer The following sections describe a number of the common configuration scenarios and how to use the configuration tools to perform these tasks. SQL Server configuration tools enable a number of scenarios that you may encounter in your daily activities.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |