Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

SQL MAC-Parallel Desktop SQL connection -SOLVED, Host and client

views
     
TSnash_ph_41
post Apr 14 2014, 10:46 AM, updated 10y ago

Getting Started
**
Junior Member
176 posts

Joined: Aug 2007
Hey guy, i'm looking a solution on this, which i'm novice on
MAC setting. maybe some of you can help me out.

Condition:

Host and client sql connection
Host install with sql express 2005 + sql management
TCP/IP enable sql browser enable.


Client is a MAC parallel desktop which i try to establish a connection between host/client
using Sql Management studio.


Encounter :
Mac ip address is same with host. while Parallel desktop have different IP range
which create itself automatic.

Currently doing research on this,perhaps can heard some suggestion from experienced
people.

Many thanks


SOLVED: Change the mac into Bridge Ethernet
At sql configuration management set the tcp/ip
All address -> add new port 1433

Set a new rule at the Firewall add port 1433

Then connect with the client address with:
192.168.1.2.1433(example)


This post has been edited by nash_ph_41: Apr 17 2014, 05:26 PM
ISawYou
post Apr 15 2014, 02:37 PM

On my way
****
Senior Member
531 posts

Joined: Oct 2011
From: Tawau -> Menumbok, Sabah(Land Below The Wind)



hmm.. I not sure if this helps, but what I did is I search the pc name instead of using IP address.
TSnash_ph_41
post Apr 15 2014, 04:57 PM

Getting Started
**
Junior Member
176 posts

Joined: Aug 2007
I trying to remote and do the setting
hope it allright

nope not good.I plan to create a bridge ethernet
for the parallel, however the option is disable

This post has been edited by nash_ph_41: Apr 15 2014, 05:17 PM
ISawYou
post Apr 15 2014, 05:24 PM

On my way
****
Senior Member
531 posts

Joined: Oct 2011
From: Tawau -> Menumbok, Sabah(Land Below The Wind)



QUOTE(nash_ph_41 @ Apr 15 2014, 04:57 PM)
I trying to remote and do the setting
hope it allright

nope not good.I plan to create a bridge ethernet
for the parallel, however the option is disable
*
So you are actually using SQL management studio to remote into the host database. Am I right?
TSnash_ph_41
post Apr 15 2014, 05:38 PM

Getting Started
**
Junior Member
176 posts

Joined: Aug 2007
Yup, as the connection able to establish then
i can apply to the program.

i try using PC name and ip like 192.168.1.1.1433
both also failure

which i check need to set bridge ethernet in order to have same ip range.
ISawYou
post Apr 16 2014, 05:37 PM

On my way
****
Senior Member
531 posts

Joined: Oct 2011
From: Tawau -> Menumbok, Sabah(Land Below The Wind)



I assume your IP range actually means same gateway. Well, the answer is yes.
TSnash_ph_41
post Apr 17 2014, 05:25 PM

Getting Started
**
Junior Member
176 posts

Joined: Aug 2007
Update : Change the mac into Bridge Ethernet
At sql configuration management set the tcp/ip
All address -> add new port 1433

Set a new rule at the Firewall add port 1433

Then connect with the client address with:
192.168.1.2.1433(example)



 

Change to:
| Lo-Fi Version
0.0120sec    0.66    5 queries    GZIP Disabled
Time is now: 28th March 2024 - 11:09 PM