login failed for user

hi,
i have developed a web application. i need to connect to sqlserver 2000
to fetch data and i am getting the following error when requested for
login page.

Login failed for user 'NT AUTHORITY\NETWORK SERVICE'

When i refresh the page it is working properly, i.e., i could see the
login screen.

what is the solution for this problem?

Kalaivanankalaivanan (mail2kalai@.gmail.com) writes:

Quote:

Originally Posted by

i have developed a web application. i need to connect to sqlserver 2000
to fetch data and i am getting the following error when requested for
login page.
>
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'
>
When i refresh the page it is working properly, i.e., i could see the
login screen.
>
what is the solution for this problem?

Looks as if the web server is trying to log in with its service account.
What does your connect string look like? Are you using Windows
authentication or SQL authentication?

If you are using Windows authentication, this is likely to be an issue
that requires knowledge of IIS (or whatever webserver you use) that I
don't. You may be better off asking in a group about IIS:

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx