Re: User ASPNET in SQL Server 2000

From: Larry Hastings (greg.@remove-me.unixsucks.com)
Date: 12/05/02 

From: "Larry Hastings" <greg.@remove-me.unixsucks.com>
Date: Thu, 5 Dec 2002 08:23:48 -0600

Then approach I suggested would not work.
You need to disable anonymous access, enable Windows access, create group in Windows, assign permissions to that group in SQL, put
users into that group, trust all accounts of users for delegation, used trusted connection in SQL.

"Tom" <tbekasiewicz@poczta.onet.pl> wrote in message news:036f01c29c5a$5d62f030$cef82ecf@TK2MSFTNGXA08...
> Hi Larry
> Thank you for post.
> But, could you explain me how can I do it.
> I want to logon to the virtual catalog from the internet
> as the windows user then I want to logon to the SQL Server
> 2000 as the same user as in Windows 2000 Server in the
> previous operation. When I logon to the IIS 5.0 from the
> internet I'am the user from the group of Windows users and
> now I want a permission to the SQL Server 2000 database
> (In the SQL Server 2000 and in the Windows 2000 AS are the
> same users, and I have a permission to all the tables in
> the database). I don't want to logon to the SQL Server as
> the user ASPNET I want to logon to the SQL Server 2000 as
> the user from the internet.
> Plese replay...
>
> >-----Original Message-----
> >If you setup System to run your ASP.NET account then
> account which would be used to access SQL server would be
> NT Authority\System
> >(for local machine) or DOMAIN\Computer$ for remote
> access. You'd have to create user in SQL 2000 with exactly
> the same name as I
> >mentioned before and then assign it permissions to
> database.
> >This shall fix the problem.
> >
> >G
> >
> >"Tom" <tbekasiewicz@poczta.onet.pl> wrote in message
> news:072e01c29b96$ec93e3f0$d5f82ecf@TK2MSFTNGXA12...
> >> Hi everyb.
> >>
> >> I use IIS 5.0 and Win 2000 AS.
> >> In my operating system I have two user accounts.
> >> The authentication in ASP.NET application is "Windows
> >> authentication". The SQL Server 2000 has "Windows
> >> authentication", and has the same users as in Win 2000
> AS.
> >> In my machine.config file I have changed the
> >> <processModel/> tag:
> >>
> >> </processModel
> >> ...
> >> userName="system"
> >> password="autogenerate"
> >> ...
> >> />
> >>
> >> In properties of virtual catalog on IIS 5.0 I have
> checked
> >> the second Checkbox - Base authentication.
> >> When I login to the server from the intrnet and I put
> the
> >> login and the password, I have got the message that the
> >> ASPNET user hasn't got permission to the SQL Server
> 2000.
> >> I want to login to the SQL Server 2000 as the user from
> >> the Windows 2000 AS system.
> >> Could you help me, please...
> >>
> >
> >
> >.
> >

Relevant Pages

  • Re: Keeping User From Deleting Table Records
    ... a regular user, if you don't grant DELETE permission, he cannot delete. ... authentication and authenticate with Windows. ... Windows or is this SQL-assigned read permission done through SQL ... user account and use Access to run a query, ...
    (microsoft.public.sqlserver.security)
  • Re: Keeping User From Deleting Table Records
    ... authentication and authenticate with Windows. ... Is this Windows "read" permission ... Windows or is this SQL-assigned read permission done through SQL ... select from any table in a database, you can put his user account ...
    (microsoft.public.sqlserver.security)
  • Re: Login failed for user (null)
    ... Not associated with a trusted SQL Server connection. ... However, if you deal with the Domain controller, most of the controls there ... > (Windows 2003 server, domain member). ...
    (microsoft.public.inetserver.asp.db)
  • Re: Login failed for user (null)
    ... Not associated with a trusted SQL Server connection. ... However, if you deal with the Domain controller, most of the controls there ... > (Windows 2003 server, domain member). ...
    (microsoft.public.sqlserver.connect)
  • Re: Login failed for user (null)
    ... Not associated with a trusted SQL Server connection. ... However, if you deal with the Domain controller, most of the controls there ... > (Windows 2003 server, domain member). ...
    (microsoft.public.sqlserver.security)
Loading