jerseyknoll Posted February 4, 2018 Posted February 4, 2018 I set up a Windows 10 VM to act as a server for my kids home school curriculum. The server utilizes a SQL database. Each of my kids has a laptop that runs the client software that needs to connect to the SQL server. Currently the clients are unable to connect to the database on the server. I have tried turning off Windows firewall on both the client and server. I know the server database is functioning correctly because I can connect to it with client software installed on the server. Any help is appreciated. Thanks.
CHBMB Posted February 4, 2018 Posted February 4, 2018 Probably better directed at SQL Server support places tbh..... Although anyone who's brave enough to teach their kids at school should get some sort of medal, whilst the rest of us enjoy the break sending them to school/nursery brings.
Limy Posted February 4, 2018 Posted February 4, 2018 29 minutes ago, jerseyknoll said: I set up a Windows 10 VM to act as a server for my kids home school curriculum. The server utilizes a SQL database. Each of my kids has a laptop that runs the client software that needs to connect to the SQL server. Currently the clients are unable to connect to the database on the server. I have tried turning off Windows firewall on both the client and server. I know the server database is functioning correctly because I can connect to it with client software installed on the server. Any help is appreciated. Thanks. Hi jerseyknoll, You haven’t said whether or not you have done this yet. Are you able to use the ping 192.168.???.??? (Or what ever address range you are using) on either computer and get replies back. If that’s working, then it appears that some ports might be blocking. Can you tell us what internal ip addresses you are using, one from your test laptop and one from your Windows 10 VM. Until you get that working, nothing is going to work.
GHunter Posted February 5, 2018 Posted February 5, 2018 SQL server connections outside the local pc are disabled by default. You have to enable them using the SQL server configuration manager. See here for details: https://social.technet.microsoft.com/wiki/contents/articles/2102.how-to-troubleshoot-connecting-to-the-sql-server-database-engine.aspx
jerseyknoll Posted February 5, 2018 Author Posted February 5, 2018 I can ping both the server IP and server name from a client. The server IP is 192.168.1.171 and one of the clients IPs is 192.168.1.223. I had no issues running the server on another physical PC on the network but was hoping to move to a VM. i read through the article above. It appears that connections to the database are enabled.
Limy Posted February 5, 2018 Posted February 5, 2018 In that case, I think the information that GHunter posted should help you.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.