My background is very much in sql 2000 and am a bit raw with 2005.
I developed a database which is a backend for a local web app. All worked fine on the development server.
I have moved this over to a 2005 sql server in production and fired everything up. Out of approx 30 users tsted so far 2 of them cannot connect via the web app. They get login failed for nt authority/anonymous user
Anon access is not turned on in iis (Windows Auth is) None of these people that failed have permissions (windows/sql) above or below those that passed.
To get the db from 2000 to 2005 I created the new db in sql 2005 and then restored the backup from 2000.
To get the logins across I did a transfer logins task from 2005 to 2000
Both tasks went fine.
I have deleted 2 of the failed users, their logins/usernames/schemas and started them from scratch. Still no good.
What's happening with these few people?