none
SQL Server setup on Parallels, cannot get port 1433 visible / working...

    Question

  • I have been trying to setup Microsoft SQL Server 2008 R2 on my Windows XP installation in Parallels desktop VM on my iMac.

    I cannot for the life of me figure out how to get 1433 visible.

    SQL Server Browser is running as NetworkService

    The server is running, with TCP/IP enabled, and appears to be listening on port 1433. IPAll TCP port set to 1433 and TCP Dynamic Ports left blank.

    I have configured parallels preferences to direct port 1433 to my Parallels IP 10.211.55.3

    I have configured my router to allow incoming and outgoing connections on 1433 with port forwarding set to my mac IP 192.178.1.72

    When I try to see if the port is open, using canyouseeme.org port 1433 does not work.

    When I run 'netstat -an' with cmd.exe it is showing TCP / 0.0.0.1433 (local)   / 0.0.0.0 (foreign) / LISTENING

    Cannot get it to work!

    If I set the port to 2100 it seems to be visible though... Cannot figure it out!  Is there a setting I'm missing?

    Saturday, July 13, 2013 9:20 PM

Answers

  • I talked with my ISP, Telus, and it's blocked.  I would have to upgrade to a business service which is what I'll look into, or will try to get another port working.

    Thanks for the help with troubleshooting anyways!

    • Marked as answer by cBarts Sunday, July 14, 2013 7:34 PM
    Sunday, July 14, 2013 7:34 PM

All replies

  • Hello,

    Please configure Windows Firewall using the following article or disable it. Windows XP SP2 (and later) has this firewall enabled by default.

    http://msdn.microsoft.com/en-us/library/Cc646023(v=sql.105).aspx


    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Sunday, July 14, 2013 1:32 AM
  • Thanks Alberto, I had forgot to mention I disabled the Windows firewall already.

    I checked the mac and it looks like the firewall is disabled as well.

    It seems like it would be something to do with firewall or port forward or something.

    Strange that when I change the TCP/IP IPAll to port 2100 it is visible on canyouseeme.org

    I will double check router and such...

    Not sure what else to try

    Sunday, July 14, 2013 3:09 AM
  • Ok well i left SQL server configuration on port 1433 and then tried canyouseeme.org on 2100 and it shows visible, so that only shows 2100 is open.

    So the problem is certainly not related to the SQL server settings, but I'm following the same methodology to open 1433 as 2100 and still cannot get 1433 to work.

    Sunday, July 14, 2013 3:20 AM
  • Hello,

    Please take a look at the following article:

    http://craigcoded.com/2010/09/01/connect-os-x-to-sql-server-express-2008-on-parallels/  

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Sunday, July 14, 2013 3:55 AM
  • Thanks Alberto

    I thought it was going to work, as they suggested adding a dedicated network adapter which was something I had not done.

    I still have the same issue, however.  Cannot see 1433 or connect to the server from a remote computer.

    I wasn't sure if when adding the second dedicated network adapter if im supposed to disable the original network connection in windows>network connections or not? It is something I will try tomorrow, but I will have to test from a different computer because my internet and such wont work if its disabled.

    Sunday, July 14, 2013 4:43 AM
  • Hello,

    Let’s wait until tomorrow. Keep us posted.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Sunday, July 14, 2013 5:48 AM
  • No luck with disabling the primary network connection.

    I tried telnet 10.37.129.10 1433 from osx terminal to ping my parallels VM machine, and it connects without issues.

    I then tried to ping my router IP in the same way and it times out. So the bust must be between the router and my mac I am thinking...

    I'm not sure what to troubleshoot. I have ports 1024 to 5000 forwarded to my iMac IP address.

    And router firewall has 1433 and 1434 open for incoming and outgoing.

    Sunday, July 14, 2013 4:06 PM
  • Not sure what a NAT table is, but on the router config screen it shows 1433 in the table. 192.168.1.72 is my mac ip address. I am not sure what 66.22.203.1 is, or how this relates...?

    Protocol Timeout Source 
    IP
    Source 
    Port
    Destination
    IP
    Destination
    Port
    6 100 192.168.1.72 56227 66.22.203.1 1433

    Sunday, July 14, 2013 4:11 PM
  • 66.22.203.1 is default gateway, so i think this is showing that 1433 is forwarded to my mac ip

    Telnet 66.22.203.1 1433 timed out however. Maybe this is the issue.

    telnet 66.22.203.1 56227 also times out. not sure why 56227 is listed there though, maybe this is irrelevant.

    Sunday, July 14, 2013 4:20 PM
  • hmm maybe NAT table is misleading that entry doesnt show up with 1433 anymore. maybe that was while i was testing with telnet
    Sunday, July 14, 2013 4:34 PM
  • I've read it may be my ISP that is blocking the port.

    This may explain why my router is showing 1433 open but it cannot be seen! 

    What a PITA.

    http://www.dslreports.com/faq/10283

    Sunday, July 14, 2013 7:14 PM
  • I talked with my ISP, Telus, and it's blocked.  I would have to upgrade to a business service which is what I'll look into, or will try to get another port working.

    Thanks for the help with troubleshooting anyways!

    • Marked as answer by cBarts Sunday, July 14, 2013 7:34 PM
    Sunday, July 14, 2013 7:34 PM