I am novice but was able to install and run DNN successfully. the connection type that i used was to attach the db to APP_Data folder mdf file (the one that auto install created) and every thing was running well.

Since later i want to run the same site on the database running on my server, i just wanted to try to move the db using to be on the sql 2005 express database and not any more to point at the MDF file under the APP_data folder. so i did this and i changed the database connectivity to use the sql 2005 express which means....

from:

<!-- Connection String for SQL Server 2005 Express -->
    <add name="SiteSqlServer" connectionString="Data Source=gtlap;AttachDbFilename=|DataDirectory|DNN.mdf;Integrated Security=True;User ID=DNN;Password=12345passme@;User Instance=True" providerName="System.Data.SqlClient" />

to:

<add name="SiteSqlServer"
      connectionString="Server=gtlap;Database=DNN;uid=DNN;pwd=12345passme@;"
      providerName="System.Data.SqlClient" />

Every thing started working except that where ever i have a link component or media components, these stopped loading no matter what i did. Does anyone know why this behaviour? what have i done wrong.

when my application loads, the link module and media module comes with these errors:

Error: Media is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Value cannot be null. Parameter name: connectionString ---> System.ArgumentNullException: Value cannot be null. Parameter name: connectionString at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Media.SqlDataProvider.GetMedia(Int32 moduleId) at DotNetNuke.Modules.Media.MediaController.GetMedia(Int32 moduleID) at DotNetNuke.Modules.Media.MediaModule.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

I appreciate any help.

regards

Hloti