ASP-Application

Hi,
i have my application running with two servers ( iis - sql
server ).
What is securest way to access from the first workstation
(iis) on the second ( sql server ) ?
With an DSN or a Connection String ?
I am running a ASP-application !
Greetings,
Daniel RakojevicYou could run your application on the IIS server under the context of an acc
ount (domain or local to the SQL server), grant this account access to the d
atabase, and then set the DSN on the IIS box to use trusted_connection=YES.
if you need to secure the data in transit, you could also enable SSL encrypt
ion on the SQL Server:
http://support.microsoft.com/defaul...kb;en-us;316898
--Roberto
-- Daniel Rakojevic wrote: --
Hi,
i have my application running with two servers ( iis - sql
server ).
What is securest way to access from the first workstation
(iis) on the second ( sql server ) ?
With an DSN or a Connection String ?
I am running a ASP-application !
Greetings,
Daniel Rakojevic