November 4, 2009 at 6:48 am
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
November 5, 2009 at 2:00 pm
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