page can not be displayed

[RichS]

I get the error:
Login failed for user 'NT Authority\Anonymous login'
/include/somepage.asp, line 12

The connection string in ASP - global.asa:
Application("connect&quot = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyDB;Data Source=MyServer"

I have added the IUSR_MyServer account to the SQL users. In IIS I have tried disabling "Anonymous Login" and using Integrated Windows Authentication. I have also tried the opposite.

The website is not on the same server as the database.

What might I be doing wrong. Any ideas are appreciated.

Rich

 

[baddos]

Why not just use SQL authentication? It would be far better than enabling the IUSR_COMPUTERNAME account.

 

[RichS]

Hmmm... this web permission thing is all kind of new to me still - I will look into how to do that.

Thanks

Rich