Post reply

Remotely Connect and Query a db.

  • September 12, 2012 at 4:18 am

    #1536629

    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 AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • September 12, 2012 at 4:20 am

    #1536631

    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 AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply