DNN Forum module errors

Install ans set up of my DNN portal has been OK so far apart from some issues with setting up domains and pointers redirecting and aliases (I've added details to other posts regarding these)
But now I am stumped!!

When trying to add a forum module in my DNN portal I get this unusual error:
A critical error has occurred.
Login failed for user 'SQL2005_281596_gorealdnn_user'

the module is added and can be moved about the page
but then when trying to access the module settings to edit it I see this error

Error: Module is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object. at DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(PortalModuleBase ctrlModule, Exception exc) at DotNetNuke.Modules.Forum.ModuleSettings.LoadSettings() at DotNetNuke.Modules.Admin.Modules.ModuleSettingsPage.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

This seems to indicate the databse hasnt been updated properly when adding the module but I cant work out why - the connect string must be OK as I have access to the site- I can add other modules OK so far (HTML/Text tried so far)

Dave Lumley

 

Please check your password attribute within your connection string in web.config

See if it looks something like this:


- Comment out the following:

<connectionStrings>
<!-- Connection String for SQL Server 2005 Express -->
<add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User
Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" providerName="System.Data.SqlClient" />
</connectionStrings>

- Add the following:

<connectionStrings>
<add name="SiteSqlServer" connectionString="Data Source=<sql server name>.discountasp.net;Integrated Security=False;Initial Catalog=<DB_Name>;User
ID=<DB_User>;Password=<DB_Pass>" providerName="System.Data.SqlClient" />
</connectionStrings>

Also,replace the following,

<appSettings>
<add key="SiteSqlServer" value="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"/>
</appSettings>

with

<appSettings>
<add key="SiteSqlServer" value="Server=<sql server name>.discountasp.net;Database=<DB_Name>;uid=<db_user>;pwd=<DB_password>;" />
</appSettings>





Vikram

DiscountASP.NET
www.DiscountASP.NET

Post Edited (vvsharma) : 9/5/2006 6:37:00 PM GMT

 

OK thanks for the response


I am now a little confused


I set up the connection string as specified in the KB article


I have now change the string to what you've suggested (I notice the explicit security setting)


Unfortunately the same error is still generated


So I have tried deleteing the modules and leaving the page - the errors dissaper


Add the forum module again and it re appears???


html/text module is ok but the FAQs module generates the following when it is added


Error: FAQs is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Login failed for user 'SQL2005_281596_gorealdnn_user'. ---> System.Data.SqlClient.SqlException: Login failed for user 'SQL2005_281596_gorealdnn_user'. at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.FAQs.SqlDataProvider.GetFAQs(Int32 ModuleId) at DotNetNuke.Modules.FAQs.FAQsController.GetFAQs(Int32 ModuleId) at DotNetNuke.Modules.FAQs.FAQs.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---





I did say before that the application is able to access the database initially as the page displays so it must be getting the page/tab id and other details - is it possibly a problem with the number of users - or tables the forum and FAQ's use more than one table do they try to attach another connection maybe???


Dave

 

The password was set to a 12 character string containing numbers and characters
when the database add on was activated - and as I seem to have to be repeating obviously works because the dnn app is able to access the databse to retrieve the information that it needs to build the page and know what modules are on the page


Dave

 

i'll try and find out

 

the reply i erecieved was


The forum does NOT use a seperate connection string. Based on the error also affecting the FAQ module, I think your web.config databaseowner or more likely, the object qualifier is off or has been changed.


I will look into this

 

Are you attachting the mdf using the SQL tools?If yes,you dont need to,since the DNN Installation process creates the schema for you.Try and delete you DB and upload a new package all over from scratch with apropriate connection string changes.Dont run DNN locally before uploading it,becoz it makes changes to the DB.
See if you still get the error?

Vikram

DiscountASP.NET
www.DiscountASP.NET