70-332 · Question #129
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 aliases used by SharePoint to connect to SQL Server are created and managed through SQL Server Configuration Manager, not SharePoint or IIS tools.
Question
Options
- APsconfig
- BSQL Server Configuration Manager
- CSQL Server Management Studio.
- DCiconfig
- EIIS Manager
How the community answered
(35 responses)- B89% (31)
- C3% (1)
- D3% (1)
- E6% (2)
Why each option
SQL aliases used by SharePoint to connect to SQL Server are created and managed through SQL Server Configuration Manager, not SharePoint or IIS tools.
Psconfig.exe is the SharePoint Products Configuration Wizard command-line tool used for farm provisioning and upgrade tasks, and has no capability to create SQL client connection aliases.
SQL Server Configuration Manager includes the SQL Server Native Client configuration section where administrators create client aliases that map a logical alias name to an actual SQL Server instance name and port. SharePoint servers use these aliases at the OS/driver level to connect to SQL Server, allowing the underlying server name or instance to change without reconfiguring SharePoint connection strings.
SQL Server Management Studio is used for database administration tasks such as T-SQL queries and schema management, but does not expose an interface for creating SQL client aliases on the application servers.
Ciconfig is not a recognized standard tool for configuring SQL aliases in a SharePoint or Windows Server environment.
IIS Manager configures web server bindings, application pools, and site settings, and has no role in creating or managing SQL Server connection aliases.
Concept tested: SQL client alias creation using SQL Server Configuration Manager
Source: https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/create-or-delete-a-server-alias-for-use-by-a-client
Topics
Community Discussion
No community discussion yet for this question.