| re: website connection to database time out problem : login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
sorry the second connection string using trusted connection should look
something like this
"PROVIDER=SQLOLEDB;Data Source=*IP_ADRESS*; Initial
Catalog=EmissionEstimations;Trusted_Connection=yes ;"
--
Regards,
HD
"Hermit Dave" <hermitd.REMOVE@CAPS.AND.DOTS.hotmail.com> wrote in message
news:%23y$PDrW2DHA.2700@tk2msftngp13.phx.gbl...[color=blue]
> you are using trusted connection and are also specifying the user name
> password... that is why when the db connection fails you get
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
>
> first remove the trusted connection... that should make that error go[/color]
off...[color=blue]
> as to why it happens after 20 mins... i am not sure...
>
> your connection should look like this
>
> "PROVIDER=SQLOLEDB;Data Source=*IP_ADRESS*;User
> Id=*USER_ID*;Password=*PASSWORD*;Initial
> Catalog=EmissionEstimations;"
>
> or
>
> "PROVIDER=SQLOLEDB;Data Source=*IP_ADRESS*;User
> Initial Catalog=EmissionEstimations;Trusted_Connection=yes ;"
>
> Second thing.. if you are using ASP.NET and are using Sql 2000 consider
> using SqlClient namespace instead of OleDb
> sqlclient is more efficient way ...
>
> --
> Regards,
>
> HD
>
> "Maellic" <maellic2002@yahoo.fr> wrote in message
> news:15aa032f.0401121538.18333996@posting.google.c om...[color=green]
> > Hi,
> >
> > The website I am working on is built with ASP.NET and connects to a
> > SQL Server 2000 database. The web server and database are on the same
> > machine. I have recently tried to modify the timeout of the website
> > from 20 mn to 60 mn. I changed the timeout setting in IIS. Now the
> > website itself doesn't time out, however after 20 mn, when I try to
> > access a page that needs to connect to the database, I get the
> > following error message
> >
> >[/color]
>[/color]
************************************************** **************************[color=blue]
> **************[color=green]
> > Form Request:
> > ASP Code:
> > Error Number: -2147217843
> > ASP Source:
> > Error Category: Microsoft OLE DB Provider for SQL Server
> > File: /emissionsestimation/includes/db.asp
> > Line: 13
> > Description: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> > ASP Description:
> > Date: 1/13/2004 9:26:08 AM
> >[/color]
>[/color]
************************************************** **************************[color=blue]
> ****************[color=green]
> >
> > If I access a page that doesn't connect to the database, it works
> > fine.
> >
> > My connection string to the database is:
> > "PROVIDER=SQLOLEDB;Data Source=*IP_ADRESS*;User
> > Id=*USER_ID*;Password=*PASSWORD*;Initial
> > Catalog=EmissionEstimations;Trusted_Connection=yes ;"
> >
> > The connection to the database works fine unless the website is idle
> > for 20 mn. After 60 mn, I get the time out message I expected. So the
> > "login failed for user" message only happens if the application is
> > left idle between 20 mn and 60 mn.
> >
> > Maybe the database has some kind of timeout setting that needs to be
> > modified as well? However why the "login failed" message ? Why this
> > user "ANONYMOUS" ? I'm kinda confused and I'd appreciate some help
> > onto why this happens and what to do about it.
> >
> > Thanks heaps
> >
> > Maelle[/color]
>
>[/color]
| 
