By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,245 Members | 1,101 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,245 IT Pros & Developers. It's quick & easy.

'nt Authority\anonymous Logon'

P: 1
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'.

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.
Mar 17 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.