70-339 · Question #134
You are the administrator for a company's SharePoint environment. All SharePoint installations must use SQL aliases. You need to complete the configuration. Which tool should you use?
The correct answer is B. SQL Server Configuration Manager. SQL Server aliases for SharePoint are created with SQL Server Configuration Manager, which exposes the SQL Native Client settings where client-side aliases are defined.
Question
You are the administrator for a company's SharePoint environment. All SharePoint installations must use SQL aliases. You need to complete the configuration. Which tool should you use?
Options
- APsconfig
- BSQL Server Configuration Manager
- CSQL Server Management Studio.
- DClconfig
- EIIS Manager
How the community answered
(33 responses)- B94% (31)
- C3% (1)
- D3% (1)
Why each option
SQL Server aliases for SharePoint are created with SQL Server Configuration Manager, which exposes the SQL Native Client settings where client-side aliases are defined.
PSConfig is the SharePoint Products Configuration Wizard used to configure farm topology and run post-installation tasks, and it has no functionality for creating SQL network aliases.
SQL Server Configuration Manager includes the SQL Native Client Configuration section where an administrator maps a friendly alias name to the actual SQL Server instance name and port number. SharePoint resolves database connections through this alias, allowing the underlying SQL Server to be renamed or migrated without modifying any SharePoint configuration.
SQL Server Management Studio is used for database administration and query execution, but does not provide an interface for defining SQL Server client-side connection aliases.
CLSConfig is the SharePoint Unified Logging Service configuration tool used for trace log settings and diagnostics, not for configuring SQL Server network aliases.
IIS Manager configures web server components such as application pools and bindings for SharePoint web applications, and cannot create or manage SQL Server connection aliases.
Concept tested: SQL Server alias creation via SQL Server Configuration Manager for SharePoint
Source: https://learn.microsoft.com/en-us/sharepoint/administration/add-a-sql-server-alias-for-sharepoint-sites
Topics
Community Discussion
No community discussion yet for this question.