Remotely Connect and Query a db.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Remotely Connect and Query a db.

17 posts, Page 2 of 2

««1 2

Remotely Connect and Query a db.

Rate Topic

Display Mode

Topic Options

Author

Message

Brandie Tarvin

Posted Tuesday, September 11, 2012 1:15 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 10:58 AM
Points: 6,655, Visits: 5,678

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, MCDBA, MCSA

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

RBarryYoung

Posted Tuesday, September 11, 2012 1:42 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855, Visits: 9,374

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

mike 61998

Posted Tuesday, September 11, 2012 2:08 PM

Grasshopper

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

RBarryYoung

Posted Tuesday, September 11, 2012 2:50 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855, Visits: 9,374

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

David Webb-CDS

Posted Tuesday, September 11, 2012 2:57 PM

SSC Eights!

Group: General Forum Members
Last Login: Today @ 4:25 PM
Points: 825, Visits: 5,690

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

Brandie Tarvin

Posted Wednesday, September 12, 2012 4:18 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 10:58 AM
Points: 6,655, Visits: 5,678

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, MCDBA, MCSA

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

Brandie Tarvin

Posted Wednesday, September 12, 2012 4:20 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 10:58 AM
Points: 6,655, Visits: 5,678

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, MCDBA, MCSA

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 »

17 posts, Page 2 of 2

««1 2

Permissions