Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...How do I install with How do I install with 'run as dbo owner' UNCHECKED?
Previous
 
Next
New Post
8/17/2010 4:30 PM
 
Roger Martin

Joined: 2/18/2007
Posts: 22
I am a module developer and am trying to test it in a DNN site where the 'run as db owner' option was UNCHECKED during the DNN installation, but I have been unable to install DNN in this configuration. Everything I try results in SQL errors. I spent quite a bit of time searching, but everything I find suggests to make sure the option is checked. I understand that, but I need to test with it unchecked, since I want to verify that my use of the {databaseOwner} replacement token in my SQL scripts is working as expected.

Things I have tried:

* Specify the 'sa' account during installation, with various tweaks such as creating an 'sa' schema with maximum permissions.

* Creating a new SQL login, adding it to the sysadmin server role and the db_owner database role, with various tweaks such as creating a schema with maximum permissions.

In other words, I am trying to minimize any chance for a permission-related error.

These are the error messages I get (which vary depending on how I tweak the permissions):

"System.Data.SqlClient.SqlException (0x80131904): Cannot find the object 'GetTabPanes', because it does not exist or you do not have permission."

"Installing Database - Version 05.00.00...FAILURE 400 - The stored procedure 'dbo.UpdateDatabaseVersionAndName' doesn't exist."

"System.Data.SqlClient.SqlException (0x80131904): Table 'EventLog' already has a primary key defined on it."

I believe this last error may be a bug, so I created a bug report.

Can anyone provide some info on installing with the 'run as db owner' option UNCHECKED?

Cheers,
Roger
 
New Post
8/18/2010 12:15 AM
 
Matthias Schlomann


Joined: 8/10/2003
Posts: 3594
You need to create a new instance with manuelly preperation of the SQL Server.

Create new Database as standard.

Go to the SQL Security and add a new user and save it.  Then reopen the users configuration and add the user to the database and type in the username as Scheme, check the dbOwner to enabled and save it.

On web.config type in the new created username and his password to the 2 SQL strings.   Don't forgot to type also the URL to the SQL server to the strings.
Set the username as the databaseOwner value.

For checking your developement please check also the objectQualifier by setting any value i.e dnn.
Regards
Matthias
DNN MVP
www.aarsys.de
Metro7 Skin
ShoutCastStats Module for DNN
 
New Post
8/19/2010 10:02 AM
 
Roger Martin

Joined: 2/18/2007
Posts: 22
I did the steps you mentioned and then ran through the install wizard, but still receive an error. When running the SQL scripts I see this:

Failure installing Database Scripts
Installing Database - Version 05.00.00...FAILURE ERROR: See D:\Development\dnn5.5\Providers\DataProviders\SqlDataProvider\05.00.00.log.resources for more information

The SqlDataProvider directory has 6 log files, none of which is named 05.00.00.log.resources. But the others all have the same message in the first row:

System.Data.SqlClient.SqlException (0x80131904): Cannot find the object 'GetTabPanes', because it does not exist or you do not have permission.

I did this on the newly released 5.5 code.

Roger
 
New Post
8/19/2010 11:17 AM
 
Matthias Schlomann


Joined: 8/10/2003
Posts: 3594
If you run install without checked execute as dbOwner you need a special SQL Server and database configuration.  I would then manuelly modify the config.sys file set the 2 SQLServer connection strings and the databaseOwner to the value of the scheme that is used on the created database.  By default it is the "dbo"! 

You have now to delete the database and recreate.  Also you have to do new extract all the DNN files and starting from the beginning.
Regards
Matthias
DNN MVP
www.aarsys.de
Metro7 Skin
ShoutCastStats Module for DNN
 
New Post
8/19/2010 11:43 AM
 
Roger Martin

Joined: 2/18/2007
Posts: 22
config.sys file? Did you mean web.config file?
 
 Page 1 of 4
1234Next 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...How do I install with How do I install with 'run as dbo owner' UNCHECKED?


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out