Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Remotely Connect and Query a db. Expand / Collapse
Author
Message
Posted Tuesday, September 11, 2012 1:15 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 8:54 AM
Points: 5,579, Visits: 6,363
mike 61998 (9/11/2012)
One is a workstation connected to the internet using Comcast (not on a windows domain), and the other is a workstation on a bellsouth connection (not on windows domain either)


Ah, that's a horse of a different color.

You're going to need some sort of SSH tunnel or VPN or something to hook these two workstations together.


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1357651
Posted Tuesday, September 11, 2012 1:42 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,294, Visits: 9,480
mike 61998 (9/11/2012)
They are not on the same network.

Ah. There's your problem.


-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #1357671
Posted Tuesday, September 11, 2012 2:08 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 20, 2012 2:55 PM
Points: 11, Visits: 19
I don't get it. both PC's have Static IP Addresses and both have SQL Remote connection settings enabled?
Post #1357685
Posted Tuesday, September 11, 2012 2:50 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,294, Visits: 9,480
mike 61998 (9/11/2012)
I don't get it. both PC's have Static IP Addresses and both have SQL Remote connection settings enabled?

As the other replies indicated, this is about security, not addressing (and not really about SQL specifically either), and there are lot of possible security gates between A and B that could be stopping you (and it's likely not just one thing either).

The first thing to do is to establish whether you can make *ANY* connection between the two boxes. So, can you ping workstation B from workstation A? Can you make any other kind of connection from A to B?


-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #1357706
Posted Tuesday, September 11, 2012 2:57 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 5:22 PM
Points: 861, Visits: 7,278
What's the error message you get? Server does not exist or cannot log in? Are you using windows authentication (probably won't work if the workstations aren't authenticating to a domain with a trusted relationship to the server) or SQL authentication?



And then again, I might be wrong ...
David Webb
Post #1357712
Posted Wednesday, September 12, 2012 4:18 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 8:54 AM
Points: 5,579, Visits: 6,363
David Webb-200187 (9/11/2012)
Are you using windows authentication (probably won't work if the workstations aren't authenticating to a domain with a trusted relationship to the server) or SQL authentication?


Honestly, I don't even see SQL authentication working unless he can build a dedicated connection between the workstations.

And notice that he did say workstations, not servers. So with two workstations not in the same building, and connecting to the internet on 2 different ISPs, we've potentially got a lot more problems here than just the basic security one.


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1357874
Posted Wednesday, September 12, 2012 4:20 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 8:54 AM
Points: 5,579, Visits: 6,363
Mike,

What OS are your workstations using?

Are these stand-alone workstations? Meaning are they the only workstations in their individual environments? Or when you say there is no windows domain, do you mean that there are no servers in these individual environments, just PCs?


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1357876
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse