All,

I follwed the video tutorial to move localhost to livehost. When I configured the Web.config file after attaching the App_Data/Database.mdf to SQL Server 2005 Express using the SQL Server Management Studio Express, I can not navigage my localhost anymore. This error was clearly warned and explained by Lee Sykes. But, I happened to be the one who cannot get it thought.

Now, my questions are
(1) I thought the and the in the Web.config are the two parts to modify to make the localhost running with the databased attached to the server to utilize full capability of SQL Server 2005 Express.
(2) I thought the User ID and Password attributes in the obove mentioned tags are the only things that are supposed to match the SQL Server 2005 Express configuration for Logins and Users parts for the newly attached Database.mdf. Is there anywhere else that I should have my User ID and Password set to be matched in the course of locacal host to live host transfer?

Thank you in advance.

Woogon

Hello,

I would double check your web.config connection code (both 2 parts) with the example web.config file that is included with the video files, it should be along the lines of:

add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress; Initial Catalog=C:\DOTNETNUKE SITES\IGFILM_DNN453\APP_DATA\DATABASE.MDF;User ID=dnncreative;Password=dnncreative" providerName="System.Data.SqlClient"

There may be something simple that you have missed such as not deleting all of the old connection code etc.

I would re-watch video 2 of the tutorial just to double check if there is a step that you have missed.

Thanks,