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

  • 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. – Randolph West Mar 12 '18 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) – Christopher Tan Mar 12 '18 at 7:17
  • Type ipconfig on the command line to get your IP address – Randolph West Mar 12 '18 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 – Christopher Tan Mar 12 '18 at 7:25
  • Yeah, you’re looking for IPv4. That’s the address your laptop got when it connected to the Wi-Fi. – Randolph West Mar 12 '18 at 7:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.