Here's my connection string:
connectionString="Server=(local);Database=mydatabasename;uid=myusername;pwd=mypassword;"
providerName="System.Data.SqlClient" />
I'm moving a website to a new server. I installed a fresh copy of SQL Express, restored the database from a sql 2000 backup. All the tables and sp's are in there. I don't know if I need to, but in 2000 you delete the user and recreate him, and give him dbo. That's what I did for 2005 Express.
Well I don't know why, but DNN gives me this error on the Install page -- it's already been installed and working on the other server. This is the error:
Error Installing DotNetNuke
Current Assembly Version: 04.00.03
ERROR: Could not connect to database specified in connectionString for SqlDataProviderSystem.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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException ...