Using Windows 7 Ultimate 64 bit.
Made a mistake of opening a VS2008 .net 3.5 wcf application in VS2010
and building it and then following the upgrade prompts.
Since then any database access from my wcf web site results in a login
failure. If I chose file as the web site then my own login is rejected
by sql server. If I publish to http, the default identity or any other
assigned to my application pool (ASP.NET v4.0) can login even though I
add it to as a user to the database.
This is driving me nuts. When I was working with .net 3.5 and VS2008 it
worked fine. I had to add the login for the identity of the application
pool (DefaultAppPool) after I published to http but then it worked fine.
If I write a simple win forms application and use select my database
using the Data Source Configuration Wizard and pick a table etc., I have
access to my database. Its not my database login credentials but
something else that WCF requires.
Can anyone shed some light on this? Please !!!!!!!!!!!!!!!!!
Otherwise I might need a new screen or notebook.
PS I ran these to try and fix things, but it resolved nothing.
"%WINDIR%\Microsoft.Net\Framework\v4.0.30319\aspnet_regiis" -i -enable
"%WINDIR%\Microsoft.Net\Framework\v4.0.30319\ServiceModelReg.exe" -r
Regards Peter
