Sql Server 2019 Error: Login failed for user . (Microsoft SQL, Error: 18456)Click to Watch Video

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.


© 2024 - ErnesTech - Privacy
E-Commerce Return Policy