Jump to content

Having trouble connecting to SQL server on Win10 VM


jerseyknoll

Recommended Posts

Posted

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.

Posted

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. :)

 

Posted
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.

Posted

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...