SQL Connectivity by Web App

From: ike (M)
Date: 06/21/04 

Date: Mon, 21 Jun 2004 17:01:19 +0100

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

Relevant Pages

  • Re: Pass Through Query Question
    ... "Joe Williams" wrote in message ... > when you mentioned setting the connection string in the properties of the ... It runs with no problem using SQL query anlayzer. ...
    (microsoft.public.access.queries)
  • Re: Cant get SQL INSERT code to work
    ... I'm not sure you can use SQL to add data to an Excel file from another ... From Access Help file (covers JET SQL): ... ' Create the connection string. ... > 'Excel file and modify the SQL statement to fit your data. ...
    (microsoft.public.access.queries)
  • Re: Dataset - Error
    ... Server connection ... So looking at this we see that it is an error coming from SQL. ... Next we would look at the connection string, which is used to "login" to SQL ... What is does specify in regards to the userid is the ...
    (microsoft.public.cert.exam.mcsd)
  • Re: EXEC master..xp_cmdshell Prevention
    ... > I found that my web application did use a connection string in a file ... > stored procedures for every SQL statement would be impractical. ... I have created a new login account ...
    (microsoft.public.sqlserver.security)
  • Re: Win2.3k and dotnet. Urgent please
    ... Did you install MSDE as an instance? ... connection string, unless it is the default instance. ... ASP.NET application and MSDE installed on our Win2k dev server. ... Then I installed SQL server client tools only. ...
    (microsoft.public.inetserver.asp.general)