Search code examples
sql-servermacosparallels

Connecting to SQL Server running on Parallels on Mac

I am running MAC with parallels installed. I have windows 7 Pro installed on Parallels, and SQLServer Express 2012 installed on Windows 7.

I am trying to connect to the SQL Server database from the Mac OS, but not having any luck.

I followed this post here, but still unable to connect. So I am thinking it may have to do with it running in a VM?

I'm receiving the following error when attempting to connect:

ERROR: An error occurred while trying to make a connection to
the database: 

JDBC URL: jdbc:jtds:sqlserver://10.211.55.4:1433;appName=RazorSQL;ssl=request;useCursors=true

Login
timed
out.

I am able to ping the IP address.

Has anyone set this up? Any tricks or pointers you can suggest?

Many thanks in advance

Solution

  • It turned out to be the firewall on Windows 7. Once I created a rule to allow traffic through on Port 1433, I was able to connect fine.

    This was done by

    1. opening "Windows Firewall with Advance Security".
    2. Selecting "Inbound Rules" > "New Rule".
    3. Selecting "Port" as the rule type, then entering 1433 as the port number to allow.