This video demonstrates how to configure your SQL Server to allow an ADO.Net connection from Visual Basic.net.
The first step is to create a login and database user. The second step is to allow port 1433 through the firewall. 1433 is SQL Server's default port. You can verify this on your SQL Server Configuration Manager. Go to properties of TCP/IP and see the TCP port.
The sample database is borrowed from Petkovic, Dušan, Microsoft SQL Server 2012: A Beginner's Guide, 5th Edition, McGraw Hill, 2012, 978-0-07-176160-4 .