I am installing DotNetNuke 7.0.4 to Windows 2008 R2 + IIS 7.5 + SQL 2012 machines. Trying to use Integrated Security on the initial database setup page but always get SQL login failed message. SQL server log shows DNN use [domainname\machinesname$] to connect to SQL server. I created this account on SQL but still get this error message. (can't find a login matching).
How can I resolve this issue? If I want to use AD authentication for my site, do I have to use this integrate security?
Thanks