Re: account aspnet access to sql server?

From: M. Zeeshan Mustafa (zeeshan_at_no-spm.please.zeeshan.net)
Date: 06/25/04 

Date: Fri, 25 Jun 2004 22:51:13 +0500

read this first http://support.microsoft.com/?id=317012

you can run your ASP.NET with a domain user, and your
SQL server would have that domain user in its users list,
this way you can easily access sql with integrated sec.

its good to understand "enabling impersonation" correctly in
that kb article. you should have impersonation disabled to use
above example. 

-- 
Hope this helps,
Zeeshan Mustafa, MCSD
"Andy" <Andy@discussions.microsoft.com> wrote in message
news:4EAA6767-56CF-48B1-818C-481A755D4EB2@microsoft.com...
> I'm trying to get the ASPNET account to be able to access a SQL Server
database (on another box). Can anyone give me any pointers please, as I'm
struggling to get to grips with the aspnet account.
>
> Am I correct in thinking that if NT user X logs onto the (intranet) page,
and the site is using windows authentication, that the aspnet account will
actually be the one accessing the database? I really don't want to start
adding each users login.
>
> If it helps, the connection string is basically "Server=myserver;
Database=mydatabase; Integrated Security=SSPI;"
>
> Many thanks in advance for any feedback

Relevant Pages

  • Re: Can my ASP.NET dev workstation see remote SQL server?
    ... If you want to use step #1 (ASPNET account) make sure you dont have ... > This domain user has been granted login on the remote SQL server, ... >> account that may be allowed access to the SQL Server ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Can my ASP.NET dev workstation see remote SQL server?
    ... If you want to use step #1 (ASPNET account) make sure you dont have ... > This domain user has been granted login on the remote SQL server, ... >> account that may be allowed access to the SQL Server ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Can my ASP.NET dev workstation see remote SQL server?
    ... If you want to use step #1 (ASPNET account) make sure you dont have ... > This domain user has been granted login on the remote SQL server, ... >> account that may be allowed access to the SQL Server ...
    (microsoft.public.sqlserver.security)
  • RE: cross database query with ownership chaining
    ... You back up a database from an instance of SQL Server 2005. ... If a domain user owns the database, the computer on which you restore the ... If a SQL Server authorization login owns the database, ...
    (microsoft.public.sqlserver.security)
  • Re: Newbie question on SQL connection
    ... > Let me educate you about SQL Server security. ... granting permissions to these accounts in SQL ... > maintain its own user accounts, which are separate from domain user ...
    (microsoft.public.dotnet.framework.aspnet)
Quantcast