seth

I'm having the craziest problem.....Any .aspx page I make
that I then run through IIS I get an error saying "Login
failed for user 'machinename\ASPNET'" but if I run the
exact same page through the WebMatrix server the page
loads with the pulled data without a hitch.

I've tried everything I can think of. It's NOT a problem
with SQL Server (obviously) but I've made doubly sure of
that by checking the user rights in Enterprise Manager.

Please...if anyone can suggest something other than re-
installing everything.....!!

ken schaefer

What permissions does Machine\ASPNET have in SQL Server?

Cheers
Ken

: I'm having the craziest problem.....Any .aspx page I make
: that I then run through IIS I get an error saying "Login
: failed for user 'machinename\ASPNET'" but if I run the
: exact same page through the WebMatrix server the page
: loads with the pulled data without a hitch.
:
: I've tried everything I can think of. It's NOT a problem
: with SQL Server (obviously) but I've made doubly sure of
: that by checking the user rights in Enterprise Manager.
:
: Please...if anyone can suggest something other than re-
: installing everything.....!!

ken schaefer

Also, please post in one newsgroup only. Kristofer has already responded in
the other group, which means I'm wasting my time.

Cheers
Ken

: What permissions does Machine\ASPNET have in SQL Server?
:
: Cheers : Ken :
: "seth" <sethx9@yahoo.com> wrote in message
: news:9f2c01c434ae$8b623700$a401280a@phx.gbl...
: : I'm having the craziest problem.....Any .aspx page I make
: : that I then run through IIS I get an error saying "Login
: : failed for user 'machinename\ASPNET'" but if I run the
: : exact same page through the WebMatrix server the page
: : loads with the pulled data without a hitch.
: :
: : I've tried everything I can think of. It's NOT a problem
: : with SQL Server (obviously) but I've made doubly sure of
: : that by checking the user rights in Enterprise Manager.
: :
: : Please...if anyone can suggest something other than re-
: : installing everything.....!!
:
:

seth

machine\ASPNET db_owner role and has been given ********
permission to every single select, insert, update,
delete, and execute...I'm very knowledgeable about SQL
Server and have already gone over everything on that end.
Which is why I've posted to a couple of IIS groups.

So sorry to have 'wasted' 30 or 40 seconds of your time
Ken but as long as the posts are on topic I will cross
post as I like. People hang out in different groups and
it is very likely that the person with the answer to my
question wouldn't read my post if it appeared in only one
group.


already responded in

ken schaefer

Yeah, you can do what you like, but if you cross-post you'll soon find that
no one will answer your posts.

Cheers
Ken


: machine\ASPNET db_owner role and has been given ********
: permission to every single select, insert, update,
: delete, and execute...I'm very knowledgeable about SQL
: Server and have already gone over everything on that end.
: Which is why I've posted to a couple of IIS groups.
:
: So sorry to have 'wasted' 30 or 40 seconds of your time
: Ken but as long as the posts are on topic I will cross
: post as I like. People hang out in different groups and
: it is very likely that the person with the answer to my
: question wouldn't read my post if it appeared in only one : group. : :
: >-----Original Message-----
: >Also, please post in one newsgroup only. Kristofer has : already responded in
: >the other group, which means I'm wasting my time.
: >
: >Cheers
: >Ken
: >
: >"Ken Schaefer" <kenREMOVE@THISadOpenStatic.com> wrote in : message
: >news:e3XR2$NNEHA.3572@tk2msftngp13.phx.gbl...
: >: What permissions does Machine\ASPNET have in SQL : Server?
: >:
: >: Cheers
: >: Ken
: >:
: >: "seth" <sethx9@yahoo.com> wrote in message
: >: news:9f2c01c434ae$8b623700$a401280a@phx.gbl...
: >: : I'm having the craziest problem.....Any .aspx page I : make
: >: : that I then run through IIS I get an error : saying "Login
: >: : failed for user 'machinename\ASPNET'" but if I run : the
: >: : exact same page through the WebMatrix server the page
: >: : loads with the pulled data without a hitch.
: >: :
: >: : I've tried everything I can think of. It's NOT a : problem
: >: : with SQL Server (obviously) but I've made doubly : sure of
: >: : that by checking the user rights in Enterprise : Manager.
: >: :
: >: : Please...if anyone can suggest something other than
: re-
: >: : installing everything.....!!
: >:
: >:
: >
: >
: >.
: >

jcochran.nospam

You need to read:

Multiposting vs Crossposting
http://www.blakjak.demon.co.uk/mul_crss.htm

You may also not want to insult those from wom you're asking help.

Jeff