Re: Server Error in '/MyWebForm' Application

From: Edward Mitchell (emitchell_at_nospam.ieee.org)
Date: 09/17/04 

Date: Fri, 17 Sep 2004 11:00:08 -0400

Greg,

Thanks for the feedback. I put ASPNET into the Administrator's group and my
web page was built. I guess this isn't the best solution for the long term
but at least, I can continue with the learning and the tutorial!

I didn't really want to become a SysAdmin but it looks like you have to know
this stuff to interface with ADO. My goal is to have an admin web page that
could create a couple of tables and a simple users page that could populate
these!

Thanks also for the info that I can get the SQL 2000 for fifty bucks. A
small price to pay if I can get some real tools. Though maybe there's too
much info in the full system:(

Regards,

Ed

"Greg Burns" <greg_burns@DONT_SPAM_ME_homtail.com> wrote in message
news:ufj2RWFnEHA.3520@TK2MSFTNGP11.phx.gbl...
> Edward Mitchell wrote:
>> Greg,
>>
>> I'm a neophyte here, just trying to get a first ASP.NET test program to
>> work.
>
> I feel your pain. :^)
>
>> I am running IIS on my XP workstation. No one else needs to get at it
>> for now.
>>
>> It seems that I shouldn't be using <identity impersonate="true">.
>
> Not needed here.
>
>> All I want to do at the moment is to run the test under my account which
>> should be the "integrated windows account" since I have admistrator
>> privileges.
>>
>
> You could connect as yourself and it would work since you are
> administrator, but this is NOT the recommended approach. Normally you
> connect to a database as a single user, not just anybody who happens to
> run your web page. This allows connection pooling to do its thing. (Of
> course, this also may not be the correct approach depending on the
> secuirty design of your database.)
>
>> I don't have SQL Server, just the MSDE engine that I can use to test.
>> The "select @@version" from osql shows Desktop Engine 5.1; SP2 though
>> after "SQL Server 2000 - 8.00.760."
>>
>
> You know you can buy the Developer Edition of SQL 2000 for under $50. This
> gives you everything in Enterpise verion of SQL, but only with a for
> development only license.
>
>
>> There is a user account on the machine "ASP.NET MachineA..." that is
>> described as a limited account, password protected although I didn't
>> create is as far as I know! I can't find an ASPNET account.
>
> You won't see the ASPNET user acount in the sugar coated Users icon in
> control panel. It is a "hidden" account by default. If your right-click
> My Computer->Manage->Local Users & Groups you will see the ASPNET here.
>
> When anonymous access is turned on for the virtaul directory in IIS, and
> your access an .aspx page, it will run under the ASPNET user. This
> account (ASPNET) is auto-created when you installed DOTNET. Its password
> is also auto-generated, so don't change it or things will break.
>
>> How would I give it rights under the SQL Enterprise Manager. Is this part
>> of MSDE?
>
> As you probably realized, MSDE does NOT come with a GUI. Hence, no
> Enterprise Manager. Sure, you can do what you need using the command
> window and OSQL, but you probably don't want to go there if you're just
> getting started. (Or even after you obtain your MCDBA!) If you plan on
> doing anything useful with SQL at all, you need to get EM.
>
>>
>> Regards,
>>
>> Ed
>
>
>
> Leave the virtual directory set to Anonymous (this is the default, unless
> you changed it).
>
> I see in another post you are using the wizards, which fortunately for me
> (unfortunate for you) I've never used. I do everything manually. Which
> makes things so much more understandable, as far as what is happening, but
> I digress...
>
> When you use either "Integrated
> Security=SSPI;" in your connection string OR "Trusted_Connection=true;"
> (they are interchangeable) you will connect to your MSDE database as the
> built in ASPNET user account (unless your also have identity
> impersonate="true", in which case you will connect as the "actual user on
> the domain requesting the page" credits to Karl).
>
> The real issue you are having is how to give the ASPNET user access to
> your MSDE instance and the specific database within that MSDE instance.
>
> I would suggest (since this is just for learning), adding the ASPNET
> account into your local adminstrators group on your PC. Any user in that
> group is also an administrator for the SQL/MSDE server on the machine.
> This is of course highly unsecure, but will still allow you to use
> Integrated Security and not have to specify a SQL username/password (which
> may not even work if your instance of MSDE is not in mixed-mode, which I
> don't think it is by default...) or to connect to your web page as
> yourself.
>
>
> HTH,
> Greg
>

Relevant Pages

  • RE: Problem Writing a File from a Web Service
    ... it should have the same permissions as my Domain account. ... That leads me to believe that the web service isn't running under the ASPNET ... actually running under the ASPNET user credentials. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Server 2003 problem with asp.net.
    ... ASP.Net does not run under ASPNET user account. ... The issue here is ASP.Net not active on Windows2003 server by default. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Getting error message HTTP/1.1 500 Internal Server Error on development machine
    ... ASPNET user into my machine's local Administrators group, ... Administrators group is NOT a good idea. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: aspnet user
    ... You don't need the ASPNET account at all. ... account needs the correct permissions set, ... >> ASPNET user account is a least priviliged (meaning cannot do anything to ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ASP.Net using a Client Certificate on IIS 6.0
    ... to use the ASPNet account and logging onto the machine as the ASPNet ... When the ASPNET user account logs in, ... >> certificate to communicate to a third party. ...
    (microsoft.public.dotnet.framework.aspnet.security)