Can't access SQL Server 2012 on virtualized environment outside LAN

Environment:

Host: OS X 10.8.5 (Mountain Lion)
Virtual Machine Application: Parallels Desktop 9
OS on VM: Windows 7 Ultimate SP1
DB Manager: SQL Server 2012 Standar



Problem:

SQL Server Instance can´t be connected outside LAN, all computers in the LAN can access without any problem the SQL Instance that is listening @ 1433 Port.

When trying to connect with the Public IP forwarding 1433 port to VM the connection is refused.



Actual Configuration:

-Router forwarding the 1433 port to the VM
-Virtual Machine configured as Bridge using "Default Adapter"
-Windows 7 Firewall disabled
-SQL Server all protocols enabled (named pipes & tcp/ip)
-SQL Server TCP-IP protocol set "IPALL 1433"
-SQL Server Listening "any 1433"
-SQL Surface Area configured to ACCEPT remote connections
-SQL Server Browser Enabled and running



Alternate configuration already tested:

With Parallels Desktop alternate config.
-Virtual Machine configured as "shared connection"
-Ports Exception created to forward 1433 port to the Virtual Machine

With SQL Server listening on 6789 port
-Router forwarding 6789 port to VM IP
-VM configured as Bridge
-SQL Server configured to listen at 6789 Port


Results:

1.- With ALL configuration the SQL Server Instance can be acceded without any problem trough the LAN

2.- With ALL configurations the SQL Server Instance connection is refused trough Public IP


meaning:

1.- If try with SSMS connect to 192.168.1.10 then success
2.- if try with SSMS connect to 187.136.XXX.XXX then fail


Could you please help me to solve this?

Thanx in Advance!
MarioMoranAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

x-menIT super heroCommented:
do a tracert to check network routing , and a telnet 187.136.XXX.XXX 1433 to check connectivity.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
David ToddSenior DBACommented:
Hi,

If you can find an old copy of SQL 2000 install media, on there is a small executable that isn't installed normally. The process to install is copy the file and rename the exertion to exe.

The file is odbcping.

It works in a very similar manner to the network ping.

It takes arguments of the server name or DSN entry, username and password or trusted security.

It can quickly validate connectivity to SQL without having to start an application or SSMS or whatever.

I've used it heaps to check connectivity through firewalls etc.

Regards
  David

PS You haven't said if you are using a named instance or a default instance of SQL. Named instances don't listen on 1433 - the SQL Browser does that; there is another port which SQL is listening on, and this is dynamic unless you fix it. Dynamic in that it possibly changes each time SQL starts.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Apple Hardware

From novice to tech pro — start learning today.