What should I do to connect to SQL Server installed in a virtual machine? Get link Facebook Twitter Pinterest Email Other Apps - February 28, 2014 What should I do to connect to SQL Server installed in a virtual machine? Get link Facebook Twitter Pinterest Email Other Apps Comments François PietteFebruary 28, 2014 at 9:22 AMThere is nothing special to do when SQL-Server runs in a virtual machine. Everything you do for a physical machine should be done.If you can't connect, firstly check for the firewall on the virtual machine, on the host machine and on the client machine.Visit my blog: http://francois-piette.blogspot.beReplyDeleteRepliesReplyPanagiotis DrivilasFebruary 28, 2014 at 9:52 AMYou must also enable TCP/IP in client and server protocols (SQL Server Configuration Manager for 2005 version)ReplyDeleteRepliesReplymezenMarch 1, 2014 at 12:00 AMand maybe you need to specify the sql instance just like SRV-PC\SQLExpressReplyDeleteRepliesReplyAsbjørn HeidMarch 3, 2014 at 5:41 PMI see you're running VirtualBox. Make sure the network type is set to bridged in the VM's properties. The other types (nat, host-only) won't work. Using bridged mode the VM will get its own IP address on the LAN, just like a regular machine.ReplyDeleteRepliesReplyJemer GaribayMarch 4, 2014 at 5:22 PMhow about checking your firewall settings on the virtual box?ReplyDeleteRepliesReplyⴰⴱⴷⴻⵔⴻⵣⴰⵇ ⵏⴰⵙⴻⵔⴷⵉⵏMarch 5, 2014 at 8:49 AMTo be honest I tried... but sadly!still trying sth else every timeReplyDeleteRepliesReplyArun SinghMarch 31, 2014 at 2:18 PMIf you can connect using SQL Server Managment Studio, then you should be able to do it within Delphi. Have you tried that first??ReplyDeleteRepliesReplyAdd commentLoad more... Post a Comment
There is nothing special to do when SQL-Server runs in a virtual machine. Everything you do for a physical machine should be done.
ReplyDeleteIf you can't connect, firstly check for the firewall on the virtual machine, on the host machine and on the client machine.
Visit my blog: http://francois-piette.blogspot.be
You must also enable TCP/IP in client and server protocols (SQL Server Configuration Manager for 2005 version)
ReplyDeleteand maybe you need to specify the sql instance just like SRV-PC\SQLExpress
ReplyDeleteI see you're running VirtualBox. Make sure the network type is set to bridged in the VM's properties. The other types (nat, host-only) won't work.
ReplyDeleteUsing bridged mode the VM will get its own IP address on the LAN, just like a regular machine.
how about checking your firewall settings on the virtual box?
ReplyDeleteTo be honest I tried... but sadly!
ReplyDeletestill trying sth else every time
If you can connect using SQL Server Managment Studio, then you should be able to do it within Delphi. Have you tried that first??
ReplyDelete