I am trying to learn how to create modules.  I bought the book "Professional DotNeNuke Module Programming" and am working my way through the first chapter. The first step of a long journey I know, but I've got to start somewhere.  I've emailed the author of the book, but also wanted to post here to see if any of you could offer insight.  

I have downloaded Visual Studio Express, SQL Server Management Studio Express, created my database, installed DNN locally in Inetpub\wwwroot and am working my way through the Install Wizard.  This is where I'm encountering the issue.  It seems that I can't connect to the database, but I'm not sure why.  I've tried every path to the database that makes sense to me, but I keep getting the error: 

Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 14
Number: 18456
Message: Login failed for user 'pattersonc'.

Do you know if this is a common problem and what advice could you offer me for troubleshooting this issue.  

Thanks in advance for any help... 

Module Rookie!

Bill,

Thanks so much for responding to my post.  It's very frustrating for me to not even be able to get past chapter 1 and the first 25 pages of this book!  Configuring the environment is not an easy task for rookies.  Anyway I appreciate it.

So updates...responses to your post

• I can not connect to the server when I try to login via SQL Server Authentication.  I can login via Windows Authentication though.  You said that if I can't login via SQL Server Authentication then something may be wrong with my configuration.  If that's the case, how would I go about changing the configuration.  Whenever I try to login via SQL Server Authentication it gives me the error "Login failed for user 'pattersonc'.  The user is not associated with a trusted SQL Server connection (Microsoft SQL Server, Error: 18452)"
   
• Also, I emailed the author (Mitchel Sellers) and he responded saying that trying to connect via web.config may be a good way and if I wasn't successful via web.config then it would give me a better error
   
• The code from web.config as it currently is (the default installation) -
  
  • 
    <connectionStrings>
        <!-- Connection String for SQL Server 2005/2008 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 2005/2008
        <add name="SiteSqlServer" connectionString="Server=(local);Database=DotNetNuke;uid=;pwd=;" providerName="System.Data.SqlClient" />
        -->
      </connectionStrings>
      <appSettings>
        <!-- Connection String for SQL Server 2005/2008 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 2005/2008 - kept for backwards compatability - legacy modules
        <add key="SiteSqlServer" value="Server=(local);Database=DotNetNuke;uid=;pwd=;"/>
        -->

Again thanks for your help and patience with me.

Regards,

Clint
 

 Bill,

Thanks so much for your help!  I finally am able to connect locally and have proceeded through the installation wizard.  Now I've got the generic site up and running locally on my machine.  While I know I'm still a million miles out, it feels good to finally get past that point.  Again, thanks so much!  Hopefully I'll be able to actually make it through a full chapter before getting stumped again.

Regards,

Clint