Has anyone got this working using integrated authentication?
I ran the Syncronize seems to have ran creates the tables and populates them. However activating it it couldn't find the DB.
Also when you go to diagnositcs is has the message.
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
Here is my connection string
<add Name="Time" ConnectionString="Data Source=XXXXXX32\IT;Database=SPTimeLogReporting;Integrated Security=SSPI" />
The MOSS farm account that app pool is running as is the DB owner for the database I created. That user also has dbcreator and securityadmin at the server.
It is SQL 2005.