G
Guest
Hi,
To start with, i'm not too sure if this is the right group to be posting in
so please let me know if these is a more suitable one.
I am trying to get my head around the mechanics behind .NET web applications
accessing SQL databases located on another pc. My current scenario is that
both PC's (IIS5 and SQL2000) are on the same domain but are physically
different. I wish to retrieve data from the database to include in the
asp.net application. As far as I can see I have two options when building
the connection:
a) pass credentials in a connection string;
b) change the impersonated user to a domain account with sql priivaleges.
I notice that the SQL box is set to use windows authentication. Does this
make a difference?
What I am looking for is are links to resources discussing the matter to
determine which method is best, if the are other methods and how to set up
the solution.
Any help would be appreciated.
Regards,
<M>ike
To start with, i'm not too sure if this is the right group to be posting in
so please let me know if these is a more suitable one.
I am trying to get my head around the mechanics behind .NET web applications
accessing SQL databases located on another pc. My current scenario is that
both PC's (IIS5 and SQL2000) are on the same domain but are physically
different. I wish to retrieve data from the database to include in the
asp.net application. As far as I can see I have two options when building
the connection:
a) pass credentials in a connection string;
b) change the impersonated user to a domain account with sql priivaleges.
I notice that the SQL box is set to use windows authentication. Does this
make a difference?
What I am looking for is are links to resources discussing the matter to
determine which method is best, if the are other methods and how to set up
the solution.
Any help would be appreciated.
Regards,
<M>ike