In order to upgrade my DNN install I need to move it to another server.  I am having difficulty with the move.
Here is what is happening:

Current: DNN 3.3.5 - MS 2000, SQL2000 
Connection string:  <add key="SiteSqlServer" value="Server=(local);Database=DBName;uid=SQLUser;pwd=SQLPassword;" />

New: DNN 3.3.5 - MS 2003, (SQL2005 on separate machine),
Connection string: <add key="SiteSqlServer" value="Server=ServerName;Database=DBName;uid=SQLUser;pwd=SQLPassword;" />

I have tested connecting remotely to the database via VS and it works.
I have tested using both .net frameworks, and have tested using SQL 2000 compatability.

Still when I try to connect I get the following error:

DotNetNuke Upgrade Error

The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] )

ERROR: Could not connect to database.

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Any help getting this working would be appreciated.

I Just checked the logs.

First, there is a messages stating that the SQL server is listening on Port 1434.

Second, No SQL log entries are made on the SQL server when I attempt to start the site(resulting in the message above).

So, Your post got me thinking.

This is a new server and the SQL server is separate and not in our DMZ while our web server is.

I looked and determined that our firewall was blocking the needed ports.

Thanks for your assistance.  Everything is up and running now.