How to set up MSQL server to accept TCP/IP connections

General Discussion
1

I am trying to do the practice test for gold certification, and my database won't connect. The error says that it is because the database is not configured for tcp/ip. All of the tutorials I can find online use an older version of Microsoft SQL Server Management Studio. Do any of you know how to configure a server to accept tcp/ip connections using Microsoft SQL Server Management Studio v20?

1 Like
2

You need to use SQL Server Configuration Manager, not Studio.
Go to your instance in it, double click it, set Enabled to YES for TCP

3 Likes
3

The fix is here in the User Manual as well:

1 Like