I use of DNN 4.3.3 and unzip it to c://DotNetNuke_2/Website and
in sql2005 create a database with name DotNetNuke and 
create a login with name DotNet and get owner premission for dotnetnuke database and
a user under my database(dotnetnuke) with name DotNet and login DotNet and
in IIS create a virtual directory to top address and with setting use of asp.net 2 and
delete web.config and development.config and rename release.config to web.config and in that doing following changes:
***red is Comments***
 
  <connectionStrings>
    <!-- Connection String for SQL Server 2005 Express
    <add
      name="SiteSqlServer"
      connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"
      providerName="System.Data.SqlClient" />-->
    <!-- Connection String for SQL Server 2000/2005-->
    <add
      name="SiteSqlServer"
      connectionString="Server=(local);Database=DotNetNuke;uid=DotNet;pwd=;"
      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=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"/>-->
    <!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules-->
    <add key="SiteSqlServer" value="Server=(local);Database=DotNetNuke;uid=DotNet;pwd=;"/> 
    <add key="InstallTemplate" value="DotNetNuke.install.config" />
    <add key="AutoUpgrade" value="true" />
    <add key="InstallMemberRole" value="true" />
    <add key="ShowMissingKeys" value="false" />
    <add key="EnableWebFarmSupport" value="false" />
    <add key="EnableCachePersistence" value="false"/>
    <add key="HostHeader" value="" /><!-- Host Header to remove from URL so "www.mydomain.com/johndoe/Default.aspx" is treated as "www.mydomain.com/Default.aspx" -->
    <add key="RemoveAngleBrackets" value="false" />
    <!--optionally strip angle brackets on public login and registration screens-->
  </appSettings>


but i get an error : can't connect to database  because in defualt  sql2005  haven't  premission to  remote  login

or error :
connection is correct but an error has accured on getting data

or error   :
the user DotNet hasn't  premission to connect to database

can you help to me ?
thanks  in advanced

The following is my connection string which works great:

<add name="SiteSqlServer" connectionString="Server=MIKEJR\SQL;Database=DotNetNukeTest;uid=mikekist;pwd=XXXX;" providerName="System.Data.SqlClient"/>

First notice my local server is identified by "MIKEJR/SQL" which is my machine name/SQL instance - the (local) in the string is just a placeholder. Also I assume you are actually entering a password but just omitted it in the post.

Good luck,

Mike

---