determining server to connect to

  • We have VB applications call a security DLL to make the database connection.

    We put an Environment Variable on our windows and web servers to indicate

    whether they are a development or production machine. This way the

    applications can be run on any server and the security DLL knows whether it

    should connect to our Development or Production SQL Server servers.

    We are looking to convert from using Mixed-Mode authentication to using

    Windows(NT) authentication. Now is a good time to review how we do this

    determination of what SQL Server server to access.

    What are other methods you have used to determine what database server an

    application should connect to?

    TIA,

    Doug

  • To be honest, I've never tried something so elaborate!

    In our environment, We have prohibited all access from desktops to production environments. The only way to connect to production is via an application and all machines that can access the prouction environment are on a special subnet (which I am also on so I can hit production from my desktop).

    Essentially, we just use network security & firewalls to determine who can connect to what servers.

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

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