Yep ... another one of these topics,
However, I've read through every other one on here, and am still unable to get this thing running.

System specs:
Windows 2003 Enterprise Server x64
IIS 6 w/ ASP .NET 2.0 32-bit (Installed and working)
MS SQL Server 2005 Enterprise 32-bit (In mixed-mode authentication. I've tried with Win Auth-Mode as well)

Web.Config file:
<add
      name="SiteSqlServer"
      connectionString="Server=(local);Database=DotNetNuke;uid=ASPNET;pwd=;"
      providerName="System.Data.SqlClient" />
  </connectionStrings>
  <appSettings>
    <!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules-->
    <add key="SiteSqlServer" value="Server=(local);Database=DotNetNuke;uid=ASPNET;pwd=;"/>

Now I've tried using both ASPNET as the user account and a separate user account (twsNuke) I've created with a password. Either one I still can't connect.

Screenshots of my SQL Server Config: