Announcement

Collapse
No announcement yet.

How connect to SQL server that is resident on a VMware virtual machine

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How connect to SQL server that is resident on a VMware virtual machine

    Hi all,

    I got a WMware virtual machine installed on my dev PC and I preferred to install SQL server express there because I will use it for a while and I don't want to put all that stuff on my PC.
    Now, I want to develop a test project and connect the database to scriptcase.
    Not being so tech guy I've no idea where to start.... ;-))
    Is there someone who can give me some hints to make it possible ?
    Thanks


  • #2
    Within your (odbc like) driver setup you must apply the correct ip and port for your database. At least this is the way it works for MySQL, and I assume that it's not different to other databases, except that the way the driver is assigned might differ (ie. tns names table for oracle etc.).
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      Hi, I know very well how do it in the same dev PC but in this case the SQL express is located in a WMware different virtual machine. It's not reachable in normal way .....

      Comment


      • #4
        If you cannot reach the database by using ip/port then you have to look at this issue. Even virtual machines have an ip, can have internet access etc.
        Albert Drent
        aducom software netherlands
        scriptcase partner, reseller, support and (turn-key) development
        www.scriptcase.eu / www.scriptcase.nl

        Comment


        • #5
          Probably missing the SQL Browser.
          Best regards: - Reinhard -

          I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

          Comment


          • #6
            Your SQL Server Express must NOT be installed as LocalDB (https://docs.microsoft.com/en-us/sql...ql-server-2017)
            It has to be installed as database engine

            From inside the VMWare, use SQL Tools to connect to your database such as tools from here: https://docs.microsoft.com/en-us/sql...ql-server-2017 or 3rd party tools like this one: https://www.apexsql.com/Download.aspx

            You need to know first that the SQL express instance is working. If you cannot connect from within the VMWare appliance itself, you will not be able to connect from outside.



            If above is working locally already, check the VMWare config.
            To minimize issues, turn off firewall inside the VMWare appliance.
            The network configuration cannot be NAT. If it is under NAT, then the VM Appliance can see your host computer, but your host computer cannot see what's inside the VM Appliance.

            So my suggestion is you do a bridge connection. This is much simpler. Then if your network connection is on DHCP, then make the guest connection also DHCP and just make sure you knos the IP. so you can configure to SC. But this will just make things hard.

            So I suggest that your guest OS inside VMWare is on Static IP so it doesn't change very frequently. Better if your network is also on static to minimize issues such as IP conflict.



            Re-Use the tools inside the VMWAre appliance, install on your host computer the tools to test whether you can already connect to the SQL Express inside VM using these tools. If still you cannot, then SC cannot connect also.

            Once you are able to connect using the tools, then there is already possibility that SC will connect...... but then again you will need the correct jet drivers to get the ODBC thing working.

            Good luck, you got a lot of troubles ahead.

            Comment

            Working...
            X