[SOLVED] Access tcp port 1433 on XP Guest
[SOLVED] Access tcp port 1433 on XP Guest
I have a new XP guest that was created from an Acronis image backup. The original XP host was a SQL Server 2005 server. It has port 1433 opened in its firewall to accept SQL Server connections. How to I make the Linux host pass port 1433 requests to the XP guest VM?
Last edited by MarkFoley on 2. May 2017, 01:19, edited 1 time in total.
-
- Oracle Corporation
- Posts: 3362
- Joined: 7. Jun 2007, 09:11
- Primary OS: Debian Sid
- VBox Version: PUEL
- Guest OSses: Linux, Windows
- Location: Dresden, Germany
- Contact:
Re: Access tcp port 1433 on XP Guest
Use NAT for your VM and use port forwarding. See section 6.3.1 in the user manual for explanations. To set up port forwarding, open your VM settings, go to network settings, Advanced, Port-forwarding.
Re: Access tcp port 1433 on XP Guest
Not working. In Settings > Network > Adapter 1 > Advanced > Port Forwarding > Rule 1, I have: Protocol = TCP; Host IP = 192.168.0.2; Host Port = 1433; guest port = 1433. See attachment.
Running tcpdump on 192.168.0.2 confirms that workstations are trying this post. On the XP VM quest I can connect to that port via telnet. I've stopped the firewall.
I must be missing something. Ideas?
Running tcpdump on 192.168.0.2 confirms that workstations are trying this post. On the XP VM quest I can connect to that port via telnet. I've stopped the firewall.
I must be missing something. Ideas?
- Attachments
-
- NAT.jpg (16.61 KiB) Viewed 10887 times
-
- Volunteer
- Posts: 5102
- Joined: 19. Sep 2009, 04:44
- Primary OS: MS Windows 10
- VBox Version: PUEL
- Guest OSses: Windows 10,7 and earlier
- Location: Sydney, Australia
Re: Access tcp port 1433 on XP Guest
Umm... guest IP?MarkFoley wrote:Not working. In Settings > Network > Adapter 1 > Advanced > Port Forwarding > Rule 1, I have: Protocol = TCP; Host IP = 192.168.0.2; Host Port = 1433; guest port = 1433. See attachment.
Running tcpdump on 192.168.0.2 confirms that workstations are trying this post. On the XP VM quest I can connect to that port via telnet. I've stopped the firewall.
I must be missing something. Ideas?
Bill
Re: Access tcp port 1433 on XP Guest
I tried putting 10.0.2.15 in there (the IP determined by running ipconfig), but that didn't help.
-
- Oracle Corporation
- Posts: 3362
- Joined: 7. Jun 2007, 09:11
- Primary OS: Debian Sid
- VBox Version: PUEL
- Guest OSses: Linux, Windows
- Location: Dresden, Germany
- Contact:
Re: Access tcp port 1433 on XP Guest
Leave the host IP empty.
Re: Access tcp port 1433 on XP Guest
Tried that too. I started with both empty, then host IP only, then host IP and guest IP. I haven't tried guest IP only, but I suspect that's not going to help. I'll try though.
-
- Site Moderator
- Posts: 34369
- Joined: 6. Sep 2008, 22:55
- Primary OS: Linux other
- VBox Version: OSE self-compiled
- Guest OSses: *NIX
Re: Access tcp port 1433 on XP Guest
Did you miss the point about using NAT and not bridged, Etc.?
Re: Access tcp port 1433 on XP Guest
I do have NAT. See image. Note that I also have Remote Display enabled for port 3389 and that works. From any host on the LAN I can connect to the VM Remote Display. From the VM's host I can `telnet localhost 3389` and get a connection. If I do `telnet localhost 1433` I get:
> telnet localhost 1433
Trying 127.0.0.1...
telnet: connect to address 127.0.0.1: Connection refused
If I try using the VM IP it timesout:
> telnet traversevm 1433
Trying 10.0.2.15...
telnet: connect to address 10.0.2.15: Connection timed out
I can telnet to this port on the XP VM itself.
There is no firewall currently enabled on the XP guest. The linux host permits all ports on the LAN, which is eth1:
iptables -A INPUT -i eth1 -p tcp --syn -j ACCEPT
iptables -A INPUT -i eth1 -p udp -j ACCEPT
It's been painful getting this VM set up so far. I'd like to use the XP VM for legacy purposes and decommission the physical machine which is suffering from old age. Surely there is a way to get access to port 1433 working?!
> telnet localhost 1433
Trying 127.0.0.1...
telnet: connect to address 127.0.0.1: Connection refused
If I try using the VM IP it timesout:
> telnet traversevm 1433
Trying 10.0.2.15...
telnet: connect to address 10.0.2.15: Connection timed out
I can telnet to this port on the XP VM itself.
There is no firewall currently enabled on the XP guest. The linux host permits all ports on the LAN, which is eth1:
iptables -A INPUT -i eth1 -p tcp --syn -j ACCEPT
iptables -A INPUT -i eth1 -p udp -j ACCEPT
It's been painful getting this VM set up so far. I'd like to use the XP VM for legacy purposes and decommission the physical machine which is suffering from old age. Surely there is a way to get access to port 1433 working?!
-
- Site Moderator
- Posts: 34369
- Joined: 6. Sep 2008, 22:55
- Primary OS: Linux other
- VBox Version: OSE self-compiled
- Guest OSses: *NIX
Re: Access tcp port 1433 on XP Guest
I am going to need to see some diagnostic information. Post the following:
Post the guests log file ( as an attachment ). Right click on the guest in the Main Manager then click show log. Save and post as an attachment. Compress if it is too large to post.
Also
From the hosts terminal/command window type VBoxManage showvminfo <VM Name> --details and post here. Replace <VM Name> with the actual name of the VM. Use " " if the name has a space in it.
Note if the host is Windows you need to be in the directory that has VBoxManage.exe for the command to work.
Post the guests log file ( as an attachment ). Right click on the guest in the Main Manager then click show log. Save and post as an attachment. Compress if it is too large to post.
Also
From the hosts terminal/command window type VBoxManage showvminfo <VM Name> --details and post here. Replace <VM Name> with the actual name of the VM. Use " " if the name has a space in it.
Note if the host is Windows you need to be in the directory that has VBoxManage.exe for the command to work.
Re: Access tcp port 1433 on XP Guest
Requests attached. The VM host is Linux.
- Attachments
-
- TraverseDetails.txt
- (4.29 KiB) Downloaded 39 times
-
- VBOXlog.zip
- (22.08 KiB) Downloaded 20 times
-
- Site Moderator
- Posts: 34369
- Joined: 6. Sep 2008, 22:55
- Primary OS: Linux other
- VBox Version: OSE self-compiled
- Guest OSses: *NIX
Re: Access tcp port 1433 on XP Guest
Code: Select all
NIC 1 Rule(0): name = Rule 1, protocol = tcp, host ip = 192.168.0.2, host port = 1433, guest ip = 10.0.2.15, guest port = 1433
Re: Access tcp port 1433 on XP Guest
OK! I deleted the rule and re-created with just the ports and guest IP. That is, I removed the host IP. That was the only combination I hadn't tried yet -- that worked, sort of. I am now able to telnet to 1433 from hosts on the LAN. Sheesh! If that is the normal rule config, it ought to be better documented.
I am not, however, yet able to connect to the database. But I think I will further explore on SQL Server forums about this first -- even though the original, physical machine can connect OK. Nevertheless, if I can telnet, I must be getting through to the VM, so I think it's reasonable to explore non-VM issues next. I'll post back.
I am not, however, yet able to connect to the database. But I think I will further explore on SQL Server forums about this first -- even though the original, physical machine can connect OK. Nevertheless, if I can telnet, I must be getting through to the VM, so I think it's reasonable to explore non-VM issues next. I'll post back.
-
- Site Moderator
- Posts: 34369
- Joined: 6. Sep 2008, 22:55
- Primary OS: Linux other
- VBox Version: OSE self-compiled
- Guest OSses: *NIX
Re: Access tcp port 1433 on XP Guest
You do not need to put the guest IP in either as the program and config file already knows what it is. As I mentioned you only need 3 things the rule, protocol, and port, nothing else.
Re: Access tcp port 1433 on XP Guest
Will try removing the guest IP later, after solving the connection issue at the XP level. I hesitate to change anything now. I did have it originally configured as you described, just ports, no IPs. The failure of that to work was what precipitated this post. Maybe there was something else I did wrong at that point, but since I'm able to connect now I'll leave well enough alone and experiment later.