Products

Solutions

Resources

Partners

Community

Blog

About

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

HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...DNN 5.2.1 DB Upgrade ErrorDNN 5.2.1 DB Upgrade Error
Previous
 
Next
New Post
12/28/2009 2:32 PM
 
@DNN Core,

Any help / suggestions or updates from the team on a fix / patch to this issue?

Thanks in advance,
Herb

P.S. The forum notifications aren't working

Wisconsins DNN User Group: www.WIDNN.com
Visit my home page: www.HerbBenton.com
 
New Post
12/28/2009 3:17 PM
 

 I have the same exact issue, error, and need the same resolution. DNN Support needs to step up and support their product. This better not turn into a finger pointing issue game.

 

System.Data.SqlClient.SqlException: Cannot find the user 'removed actual user name for security purposes', because it does not exist or you do not have permission. 
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) 
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) 
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) 
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) 
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) 
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) 
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() 
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) 
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) 
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) 
at DotNetNuke.Data.SqlDataProvider.GrantStoredProceduresPermission(String Permission, String LoginOrRole) 

GRANT EXECUTE TO [removed actual user name for security purposes

 
New Post
12/28/2009 3:30 PM
 

not sure what you mean by a finger pointing issue. If you have issues with the paid DNN Support, I suggest you take it up with DNN Support, and not communicate through these forums.

With respect to the error discussed here, i noticed this myself too. The way i set up my local db's is to have DNN connect with an SA account. Not secure, but other than that extremely usefull in a development environment. I got the same error on th  SA account, and of course, the account had no explicit rights on the DB. After i gave that account explicit rights as DBO on the database, DNN installed just fine. So while this will not fix the issue, you might want to check wether or not the account has explicit rights to the db.


Erik van Ballegoij, Former DNN Corp. Employee and DNN Expert

DNN Blog | Twitter: @erikvb | LinkedIn: Erik van Ballegoij on LinkedIn

 
New Post
12/28/2009 5:21 PM
 

For those users with issues on the upgrade, with the user error.  Your hosting provider should be able to grant your user DBO permissions, which will resolve the errors that you are encountering.

If they are not willing to do this, you will want to talk with your hosting company, as DBO permissions are something that are really needed at least from an install/upgrade perspective due to the nature of DNN.

Depending on your hosting provider, this shouldn't be an issue.

If you have specific questions, feel free to e-mail me directly at msellers@iowacomputergurus.com as I am not receiving e-mail notifications from the forum at this time.


-Mitchel Sellers
Microsoft MVP, ASPInsider, DNN MVP
CEO/Director of Development - IowaComputerGurus Inc.
LinkedIn Profile

Visit mitchelsellers.com for my mostly DNN Blog and support forum.

Visit IowaComputerGurus.com for free DNN Modules, DNN Performance Tips, DNN Consulting Quotes, and DNN Technical Support Services
 
New Post
12/28/2009 7:47 PM
 

>/* Set DataType List to be a SystemList */
>/****************************************/
>
>UPDATE Lists SET SystemList = 'True' WHERE ListName = 'DataType'
>
>[end]

I too have found this problem.  It would seem as though the 5.2.1 install/upgrade script hasn't had the {objectQualifier}.

This showed up over about 6 different attempts to install, across two different operating systems and three different sql server versions, all trying to work out where the problem was.   I received various errors, some pointing me to the sqldataprovider log file, and another with a "FAILURE 400 - Generic failure" - which I have never seen before. 

Also, unlike before, you can't re-run the install or you'll trip over the new code which is designed to stop scripts from running.  The symptom is a flashing screen with an 'undefined' error continually scrolling causing an infinite loop.  This means you have to dump your database and start again if something goes wrong during the upgrade process.  This isn't as good as before.  Perhaps the anti-hacking measures could be disabled until the system is first run and the install is finished?

The solution for me (while waiting on 5.2.2) is to update the 5.2.1.SqlDataProvider file (before running the install) so that the above line

UPDATE Lists SET SystemList = 'True' WHERE ListName = 'DataType'
 

Is changed to

UPDATE {databaseOwner}{objectQualifier}Lists SET SystemList = 'True' WHERE ListName = 'DataType'
 

I think a test of the install script including an objectQualifier in the web.config is probably needed for the release process.  I know that using an object qualifier isn't popular, but I always use this to test out my modules, as it is an important part of compatibility.

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...DNN 5.2.1 DB Upgrade ErrorDNN 5.2.1 DB Upgrade Error


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