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 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 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:
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. Cannot find the object 'UpdateEventLogPendingNotif', 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 Dev that wants Host access, I can provide that.

We are using DNN 5.6.1 and SmithCard 4.26 Trial

Thanks in advance,
Jeremy Close

This is a separate install with a different issue. I looked to see if it is related, but it isn't.

I believe this to be a DB owner config issue, but haven't been able to track it down exactly due to not really knowing what I am doing.

Any help would be appreciated.

Thanks,
Jeremy

We use shared hosting on 3essentials.com

Here is the connection string:
connectionString="Data Source=DB2.3ESSENTIALS.COM;Initial Catalog=hickoryriverdog_dnn;User ID=XXXXXXXXX;Password=XXXXXXXXX" providerName="System.Data.SqlClient"

Let me know if you need any other info.

Thanks

 

I would like to see the very first error, but it looks like you are in the wrong database or have incorrect permissions for some strange reason.

 

Do you have access to SQL Server Management Studio? If so, login to your database, using the credentials provided, and click New Query. (If not, login as host and select host|sql. You can run these examples, but not fix the problems easily.)

 

select db_name()

 

Click execute. What database is returned? If this is not the correct database, then you should assign the default database to the user.

 

Connection|Security|Logins, right click user, properties. Under general, select the default database.

 

Under User mapping, .select the database, then scroll down the roles and ensure db_owner is selected. Select ok.

 

To verify the user has  db_owner execute this

 

exec  sp_helprolemember

 

This proper SQL setup must be working before installing DNN.

 

As far as automating installation, simply drop smithcart into the ~\Install\Modules folder before installing DNN. When DNN is installed (or manually using domain\install.aspx?mode=install) any zip files (modules) will be installed automatically.

DNN/SQL problems are often caused by mixing improper credentials. What many people do is try it first, then fix the problems as they appear. This does not work well with DNN/NTFS/SQL/IIS because they are inter-related and have installation requirements in a specific sequence. As a user you can drop files into a folder, but running under the context of a web application pool may not have similar permissions. Adjusting folder or SQL permissions AFTER seeing error messages, does not reapply the scripts or steps that caused the error.

With DNN you can get yourself in a real mess if it is not configured properly BEFORE firing up the website and installing modules.

Please keep us posted and if you require further assistance just let me know.