Hello,
To configure MS SQL service you need to connect the server via RDP and then open SQL configuration manager >>> expand the option ” SQL server network configuration” >>> select protocol TCP/IP >> right click on it >>> enable.
You need to enable only TCP/IP, Named pipes, Shared memory.
Once you enable TCP/IP protocol and open it >>click on IP address >>> assign default MsSQL port and enable IPv4.
Regards,