Access SQL Server Management Remotely

Access SQL Server Management Remotely

If you would like to access SQL Server Database Engine remotely, on Windows, search for Firewall on your computer then click on Inbound Rules. The wizard pops up. Right Click and navigate to New Rule, then click on a port(and the standard port SQL is TCP)(Specific port is 1433(Specify)) Click next. Allow the connection and If you want the connection to happen on your Domain network, then checkbox. Click next, then give it a name e.g. "Allow SQL 1433". When you hit finish you will see a new port was created. That will allow traffic inbound to your SQL server.
[NB] If you want to download and install the database to practice on, go to adventure Works sample DB website.