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?
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
The fix is here in the User Manual as well: