I have a DNN Installation where the webserver for DNN is on one machine and the database is on another.  I need to move the database from Standard SQL 2005 server to the webserver which is running the express edition of sql.  I have backed up the database and recovered it to the express edition.  What I don't understand is the connection string to use in the web.config file.  Can I just change the server setting to point to the new database on the express edition on the webserver if I dup the username and database name from the SQL server to the Webserver?

From the SQL Server
<add name="SiteSqlServer" connectionString="Server=SQLDEV\SQLDEV1;Database=DNN_Intranet2;uid=DNN_Intranet;pwd=DNN_Intranet;" providerName="System.Data.SqlClient" />

To the Web Server
<add name="SiteSqlServer" connectionString="Server=WEBSERVER\SQLEXPRESS;Database=DNN_Intranet2;uid=DNN_Intranet;pwd=DNN_Intranet;" providerName="System.Data.SqlClient" />

Tried that, but I am getting errors on the test site

When I do try this I am getting an error of "The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist."

I guess I don't know how to connect to the database on the sql express.  On this web server I have another DNN installation that is using the sql express, is that going to interfear with moving the database over from the SQL server to the express?

Any help or ideas?

If you need more info try this post:

http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/107/threadid/82012/scope/posts/threadpage/1/Default.aspx