Okay, here's an interesting issue we can't seem to resolve.  I'm open to suggestions on this one.  I'm at a complete impass on this one.

We've installed DNN v4.0.3.  SQL database [2000] is installed.  I've installed several skins, plus some modules.  I can get modules to insert on the page, but getting major errors with them.  I can't edit/alter them at all.  When I'm logged in as HOST on it, the errors I'm getting are expanded to the following:

DotNetNuke.Services.Exceptions.ModuleLoadException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) ---> System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at....

...and it goes on from there.  If you need the full error, I can repost it.  According to the server guys, they installed the SQL database properly: [from email] The databases are on a separate server; they are SQL Server 2000 databases. If you take a look at web.config for each site, the connection string is there. Each database has its own user which is the db owner, so you can make changes with that account as needed.

I was chatting w/ a friend who had set up a DNN site for me in the past and had him look at it.  Here's our chat:

[13:43] Jason: .. it doesn't make sense.
[13:44] Andrew: Is there anything you can tell me that I can keep in my notes if I'm able to get someone from DNN to help me?
[13:46] Jason: ... only that it is looking for a SQL Server 2005 box, but the DB is 2000
[13:47] Andrew: they should still be compatible, shouldn't they?
[13:47] Jason: Well, yes -- but why is the site thinking it is 2005???
[13:48] Andrew: I dunno... is there a setting in the login for DNN that would make it do that?  This is where I'm lost
[13:48] Jason: There isn't...
[13:48] Jason: this is why I am lost too.

I have all the logins/passwords if someone thinks they may be able to assist me on this.  I can get you all the info you need, I just don't know what you need to know.  I really don't want to use anything but DNN as I use it on other sites and love it's functionality and ease of use.  CAN ANYONE HELP?

Thanks!

Andrew Cannon, operations manager
Vox Communications: WAVK/WWUS/WCNK/WWWK Radio
The Florida Keys
voxandrew@bellsouth.net

connectionStrings & appSettings are below.  SQL database is a 2000 SQL.  If there's anything else in the way of info you need, I'd be happy to pass it on to get some help.  Once I get this up and running, I'll be fine from there... I'm just stuck at the moment.  Thanks in advance for all your help.

-andrew

=========================

  <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=******;Database=******;uid=******;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=;pwd=;"/>
    -->
    <add key="InstallTemplate" value="DotNetNuke.install.config" />
    <!--  Alternative Install Templates (included in package)
    <add key="InstallTemplate" value="Club.install.config" />
    <add key="InstallTemplate" value="Personal.install.config" />
    <add key="InstallTemplate" value="SmallBusiness.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="InstallationDate" value="5/5/2006" />
  </appSettings>

//MODERATOR EDIT - Removed sensitive information
Please REMOVE your connection strings when posting... AND MODERATORS - please check the connection strings have been removed prior to approving!!!

A combination of late night stupidity and a blonde moment left that sensitive information out there.  I reallt should have looked it over before hand. 

I'll pass this on to our server guys and let them handle it from here.  Thanks.