it looks like you misconfigured your installation. you should not use another databaseowner in your web config, if not explicitely requested and set up by our host.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN

OK - but I'm not sure what to do about it.  It is happening with just about every module that I try to load.  The error posted in this thread was from trying to upload the core links module.  I assume that I need to change a script somewhere, but I don't know if the sqldataprovider script that you mentioned is module specific or if there is there one that all modules use.  Would I have to search through all the stored procedures and make changes or is there a central place where this is controlled?  I Just don't know where to go next.

I don't think there is an error in my installation as suggested by Sebastian, since the  HOST has it set up to automatically add the object qualifier when a table is created (apparantly a lot of hosts do that), and that parameter is set up properly in web.config  Apparantly the system objects always have 'dbo' as the owner, so i don't have any choice in the  matter.

It seems like I need to find all the places where the script(s) specifies {databaseowner}.sysobjects and change it to dbo.sysobjects.

I found this in the bug reporting database:
"There is a bug when installing with the config setting of databaseowner different than "dbo".

If you do so, some core modules will not be installed because the SQL-Scripts requests the {databaseOwner}sysobjects table instead of dbo.sysobjects. This will result in failing such modules like HTMLText and others.

Please change the scripts in the ...SQLDataProvider files to dbo.sysobjects or better to INFORMATION_SCHEMA.TABLES (Microsoft recommendation)"

I don't totally understand what thie above quote refers to, but it looks like there may be a more generic method of referring to the sysobjects table.

Any suggestions as to where these changes should be made? - an example would be really good.

Any solution to this problem.... I am having the same issue?