Posted by Erland Sommarskog on 06/30/31 11:57

kalaivanan (mail2kalai@gmail.com) writes:
> 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/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Facing some problem in Instead of Trigger for MultiRow Insert
• Prev in forum: Re: MSSQL2K5 Install Path
• Thread view: Re: login failed for user

[Reply to this message]