First off, let me say that I am relatively new to DNN and am still working through a lot of things I don't understand, so if I phrase things poorly, I am sorry.

I have a error when trying to install FormAndList that I am getting on multiple DNN installs. The background on this is that we wanted a faster way to launch DNN sites, so we created a base line install that we have been copying to separate hosting for new sites. (We now realize there are issues with this that we are now having problems with.)

The error we are getting looks to be related to the System.Data.SqlClient or database owner settings in web.config or possibly permissions in the actual DB (Again, I am only guessing here).

Below is a small sample of the error we are getting for reference, the error is about 50 times the size of the sample, thus I don't want to include the entire thing. It looks to be going through every field in the DB for some reason and not being able to find/update them.

Error Sample:
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Cannot find the object 'Smith_DeleteCustomer', because it does not exist or you do not have permission. Cannot find the object 'GetTabModules', because it does not exist or you do not have permission. Cannot find the object 'GetTabPanes', because it does not exist or you do not have permission. Cannot find the object 'UpdateSkinControl', because it does not exist or you do not have permission. Cannot find the object 'DeletePortalDesktopModules', because it does not exist or you do not have permission. Cannot find the object 'Smith_GetCustomer', because it does not exist or you do not have permission. Cannot find the object 'CalculatePagingInformation', because it does not exist or you do not have permission.

If there is anyone that can give some guidance without host access, that would be appreciated. If there is a FormAndList Dev that wants Host access, I can provide that.


Thanks in advance,
Jeremy Close

Thanks for the quick response. Is there any way you could verify this if I provided you host access? I am still new enough to DNN to not really understand what you just said, and have no idea about what we can do about it if this is the case.

Thanks,
Jeremy