Below is the connection string that I am using.  I have mapped the DNN db and granted dbOwner permissions.  I am setting the

server name = BOSWELL-078F2A0\SQLEXPRESS

Database name = Database.mdf

I have integrated security unchecked and setting the

User ID = dnnuser

Password = raymond1

I have Run as db owner checked

I left Object Qualifer blank

<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=BOSWELL-078F2A0\SQLEXPRESS;

Database=DotNetNuke;

uid=dnnuser

;pwd=raymond1;"
      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=BOSWELL-078F2A0\SQLEXPRESS;

Database=DotNetNuke;

uid=dnnuser;

pwd=raymond1;"/>

 

I receive the error message Login failed for user dnnuser. the user is not associated with a trusted SQL Server Connection.

 

I then tried checking the checkbox for Intergrated Security and receive the error message

Cannot open database Database.mdf requested by the login. The login failed for user Boswell-078F2A0ASPNET.

 

I changed the Database name to Dotnetnuke.mdf and receive the serror.  Cannot open database Dotnetnuke.mdf requested by the login. The login failed for user Boswell-078F2A0ASPNET

Any Suggestions

Thanks,

Wbosw