I recently switched to SQL Express from SQL Server 2005.  In SQL Server, I created a database in Mgmt Studio, then modified my connection string and ran.  Everything worked.  Now I want to use that same database with SQL Express.  What does the connection string look like, AND where do I put the MDF file?

Original connection string looks like this:

<!-- Connection String for SQL Server 2000/2005 -->

<add name="SiteSqlServer" connectionString="Server=(local);Database=dnn402;uid=dnn;pwd=dnn;" providerName="System.Data.SqlClient" /></connectionStrings>

<!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules -->

<add key="SiteSqlServer" value="Server=(local);Database=dnn402;uid=dnn;pwd=dnn;" />

<add key="InstallTemplate" value="DotNetNuke.install.config" />

Thanks Rugbymw.

I tried that string with the .mdf file in the app_data folder, and it didn't work.  I also tried putting the uid and pwd in the string in both places - still didn't work.

I'm guessing many people do or have done this and i just am not using the correct vocabulary to search for it.

Now I seem to be able to run any databases I create in SQL Express, but I can't run the database I created in SQL Server 2005 Enterprise Edition.  Here's the error I get.

"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.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) ...  "