Please Login to Continue

Free Software Development Articles.Email List

Advertise Here

Access SQL Server Management Remotely

Access SQL Server Management Remotely

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.
Technology published
Buy Me Coffee

Was this page helpful?

Yes Yes! this solution to the problem was helpful. No No! this solution to the problem was not helpful..



© 2020 - ErnesTech - Privacy