Ok, I am about to pull my hair out.  I have followed the instructions just as they are in the Install PDF, and I am getting this error:

Error Installing DotNetNuke

Current Assembly Version: 04.04.01

ERROR: Could not connect to database specified in connectionString for SqlDataProvider

I have researched on here regarding this, and people say that the connection string is not right or whatever.  Well, there's only a few spots to change, and I have triple checked; there isn't anything misspelled.

Please help.  I just want to try this out, and so far, I am not that impressed because I cannot even get it up and running.

Thank you.

Sorry. . . It's been a long day. . .

Yes.  I can connect with the credentials that I used in the web.config file.

I'm on a Windows 2003 box with SQL 2000.

I literally followed the instructions step-by-step, and I get that error.  And I have checked to see if SQL will allow remote connections, and it will.  The NTFS permissions are fine, which by the way, is not always NETWORK SERVICE, it is also ASPNET.  But in either case, they're fine.

I did try it on my local machine (Windows XP) with SQLEXPRESS, and it seems to work, but not on the 2003 box, with SQL 2000.

Any help would be greatly appreciated.  And after I get this up and running, I want to allow people to log-in, using Active Directory, but that's later.

Thanks!

Ok, ok. . . I found the problem, and it is a typo on DNN's part, not mine.  The directions aren't as explicit as some would think. . .

By default, the SQLSERVER string is commented out, but the close comment "-->" is on another line return.  I did not see it (like I said, long day).  If you're using SQL2000 or 2003, comment the SQLEXPRESS line, and make sure that the other line is not commented out.

<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=;pwd=;"
      providerName="System.Data.SqlClient" />
   -->
  </connectionStrings>

That was the problem and it works now.  It may also be that I used Notepad, rather than something else as well.

I knew if I walked away for a while and came back, I would see something.

Thanks,

D

P.S. - And don't make fun of me.