'nt Authority\anonymous Logon'

[Nomad50]

I have SQL 2005 running on a server 2003 computer (Docro-Svr2) and a server 2000 computer (Docro-Svr1) running our Intranet site using IIS ver 5. I am using a DSN-less connection from an ASP script to connect to and access the database files.

As long as I run the ASP script from a browser on the Intranet server the script works fine. If I go to any other computer on the domain, the script fails with the following message:

Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

The CATCH:
If I go back to the Intranet server and refresh the screen (F5) in the browser (IE6 or IE7), then go back to any other computer on the Domain and refresh the browser screen on that machine, it works fine for about 30 seconds, then times out and fails. However, I can refresh the browser screen on the Intranet server and immediately go to that other computer and the script will works for another 30 or so seconds..

The connection string is:
con.connectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Docro;Data Source=DOCRO-Svr2"

I am using "Windows Authentication Mode" and it does not make a difference as to who is logged in, including administrators.