Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
server connection / what server to connect to
0 views
Skip to first unread message
Doug
Oct 30, 2009, 10:19:01 AM10/30/09
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 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
0 new messages