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?
KalaivananIt sounds like the web application is trying to connect using the system
account. Give it a user account (non sa) which can logon to the sql server.
Also verify that SQL Server is not running under the local system account.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"kalaivanan" <mail2kalai@.gmail.com> wrote in message
news:1157353804.602345.216230@.i3g2000cwc.googlegroups.com...
> 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?
> Kalaivanan
>