Exam 70-462 topic 2 question 202 discussion

Actual exam question from Microsoft's 70-462

Question #: 202
Topic #: 2

You install SQL Server on a new server named SQL1 and create several databases.
Users report that they fail to connect to any of the databases on SQL1.
You discover that the TCP connections are disabled for the database engine on SQL1.
You need to ensure that the users can connect to the databases on SQL1.
What should you use?

A. the SQL Server Installation Center
B. the sp_configure stored procedure
C. SQL Server Configuration Manager
D. the ODBC Data Source Administrator C

Show Suggested Answer

Suggested Answer: Explanation 🗳️
To enable the TCP/IP network protocol
1. Start SQL Server Configuration Manager. Click Start, point to All Programs, and click Microsoft SQL Server. Click Configuration Tools, and then click SQL
Server Configuration Manager.
2. In SQL Server Configuration Manager, in the console pane, expand SQL Server Network Configuration.
3. In the console pane, click Protocols for <instance_name>.
4. In the details pane, right-click TCP/IP, and then click Enable.
5. In the console pane, click SQL Server Services.
6. In the details pane, right-click SQL Server (<instance_name>), and then click Restart, to stop and restart the SQL Server service.
References:
https://technet.microsoft.com/en-us/library/hh231672(v=sql.110).aspx

by Varad at Oct. 1, 2019, 8 p.m.

Comments

Submit Cancel

King_W

4 years, 5 months ago

Configuration Manager

upvoted 1 times

...

Varad

5 years, 7 months ago

C. SQL Server Configuration Manager

upvoted 3 times

...

Exam 70-462 All Questions

View all questions & answers for the 70-462 exam

Exam 70-462 topic 2 question 202 discussion

Comments

King_W

Varad

SY0-701