How are other computers able to connect to my database
UDP 1434 is only for the discovery of database and port. If you still have named pipes enabled and provide the correct name or IP Adress of the host where your database is running and it runs on default port 1433 you will be able to connect. With right username + password.