Access SQL Server Management Remotely

Click to Watch Video

If you want to access SQL server management 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.

Edit this Article
If you log in, you will be notified when someone leaves a comment.

Other users would like to know if this solution helped you.

© 2022 - ErnesTech - Privacy