2

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.

Additional information:

  • 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

11
  • If your laptop is at school, and you're connected to the Wi-Fi, you just need the IP address of the laptop (and the appropriate port 1433 open on the laptop firewall) in order to connect to SQL Server. Mar 12, 2018 at 7:01
  • My sql server is on my laptop, I cant seem to find the dns server address to set the ip configuration? (Not shown in cmd) Mar 12, 2018 at 7:17
  • Type ipconfig on the command line to get your IP address Mar 12, 2018 at 7:20
  • 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 Mar 12, 2018 at 7:25
  • Yeah, you’re looking for IPv4. That’s the address your laptop got when it connected to the Wi-Fi. Mar 12, 2018 at 7:28

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.