It sounds like something went wrong with your installation, causing the database scripts to not install right, or the database it is connecting to is wrong.  If you can verify that the database being connected to is not correct, then correct it in the SiteSqlServer connection string (in connection strings and appsettings).  Otherwise, I would suggest starting the DNN install over.  Also, you probably already know this, but the source version should not be used for a live site.

still the same error.. by the way.. here's my connection string in my web.config file.. hope someone can help...

<connectionStrings>
  <!-- Connection String for SQL Server 2005 Express -->
  <add name="SiteSqlServer" connectionString="Data Source=bryanqp\sqlexpress;Integrated Security=True;Initial Catalog=DNN462;User ID=bryan;Password=12345678" providerName="System.Data.SqlClient"/>

 </connectionStrings>
 <appSettings>
  <!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules   -->
  <add key="SiteSqlServer" value="Data Source=bryanqp\sqlexpress;Integrated Security=True;Initial Catalog=DNN462;User ID=bryan;Password=12345678"/>
 
  <add key="InstallTemplate" value="DotNetNuke.install.config"/>
  <add key="AutoUpgrade" value="false"/>
  <add key="UseInstallWizard" value="false"/>
  <add key="InstallMemberRole" value="true"/>
  <add key="ShowMissingKeys" value="false"/>
  <add key="EnableWebFarmSupport" value="false"/>
  <add key="EnableCachePersistence" value="false"/>
  <add key="HostHeader" value=""/>                                                                                                                                                                            <add key="RemoveAngleBrackets" value="false"/><!--optionally strip angle brackets on public login and registration screens-->
  <add key="PersistentCookieTimeout" value="0"/><!--use as persistent cookie expiration. Value is in minutes, and only active if a non-zero figure-->
 </appSettings>