MSSQL Configuration Tips

Happened to me hence jot down here for future reference, perhaps helpful to you also 🙂

Try to configure the TCP port as below from Sql Server Configuration Manager:

Try to configure as below from Microsoft SQL Server Management Studio: