A critical error has occurred.
Login failed for user 'SQLdnn_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)

 

a different connection string was suggested and tried (it had extra about server id and security)

 

I tried a bit more testing and then got

 

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 'SQLdnn_user'. ---> System.Data.SqlClient.SqlException: Login failed for user 'SQLdnn_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 was asked to check if I had updated my passwork in the control panel which I duly ensured was done and reset the details in the connection string\

 

I can see some modules and pages so it is clear the database is being accessed and updated  but these modules obviously cause problems

I have been asked to verify:

Could it be that it (forum module) uses a different connection string?

Does it??