WCF 4 Step by Step example

Question

I recently purchased WCF 4 Step by Step Microsoft press publication. I'm work through the first chapter. I have encountered a strange issue which has me at my wits end.

I'm using VS 2010 and SQL server 2008

I deployed a service to IIS local. When instantiating the client and calling methods I'm prompted with the error below:

Login failed for user 'IIS APPPOOL\ASP.NET v4.0'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>].

The user 'IIS APPPOOL\ASP.NET v4.0' is a member of the db_owner role.

Please any suggestion would be greatly appreciated.

---

dblk

Answer 1

Most likely the message before this in the logs is: Error 18456 (Severity: 14, State: ???)   If so, the State number is important.

Look here: http://sqlblog.com/blogs/aaron_bertrand/archive/2011/01/14/sql-server-v-next-denali-additional-states-for-error-18456.aspx

Find the State number and that will probably explain your problem.   For example: State 8 in an incorrect password.

One other thing to examine, although it seems unlikely:

http://www.sqldbops.com/2010/05/token-based-server-access-validation.html

RLF

Answer 2

I resolved this issue by setting the ASP.NET 4 application pool to run as a localservice not sure if this is the correct procedure but it works

---

dblk