I am doing a school project where I have to set up a SQL Server database for my teammates to work on. Currently, I am able to host the server online with my home router, but I am facing problems bringing the database server to school, where the Wi-Fi does not allows me to do port forwarding.
I only have one laptop and the database server needs to be available online while connected to the school's secured Wi-Fi.
Hence, what would be the best way to host the database server in school? (using SQL Server) Secureness of the database is not an issue.
- SQL Server is on my laptop, I cant seem to find the DNS server address to set the IP configuration? (Not shown in cmd)
- There is only connection specific DNS suffix, link local ipv6, ipv4 address, subnet mask, default gateway, and connection specific DNS suffix, ipv6 address, link local ipv6 address, default gateway.
- I can connect to my own server but no one else can connect to it as I cannot establish an internet connection without a DNS server IP dynamically given by my school Wi-Fi
- We use another computer with the same iPv4 properties (IP address) on the same Wi-Fi and the same server name on SQL Server and this issue came up:
named pipes provider: error 40, could not open connection to server