Hi!
The connection sound indicates that both the cable and the port are working, so the issue might lie within the phone's settings. By default, phones connect only for charging. To enable file transfer (MTP), a notification should appear on your phone; tap it and select the file transfer option. You can also check your phone's settings to see if there is an option to enable this.
If you have already tried this, the issue might be related to the Windows MTP driver. Before I suggest a specific solution, please perform the test mentioned above.