I have XP Pro installed with SQl Server 7.0. I use Visual
Studio.NET for programming ASP.NET(IIS is also
installed).When I run this, I get an error message
"login failed for user VENKY/ASPNET".
I did some search and many poeple seem to have these
errors but not one page says what is to be clearly done
for XP platform. One page said that I have to create a
domain user ASPNET and see to that this user has access
rights to SQL Server. COuld someone please tell the steps
to do this. Thanks a lot in advance.
Originally posted by rnealejr
Is your sql server and iis running on the same machine ? What is your anonymous login set to under iis ?
Yes they are running on the same machine. Sorry what do you mean by anonymous login, where do you go and see that. Anyway yesterday we solved the problem somehow, did further research on the web and somehow solved it.
To check the anonymous account used in iis - go into internet service manager. Right click on 'default web site'. Click on 'directory security' -> click edit under 'anonymous access ...) -> click edit under 'anonymous access'.
The solution may have been adding that username to sql server or the anonymous access login to sql server.
For future reference - the following is a helpful article from ms: