There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
The database user is not being created with the DNN 6.0 wizard
A bug have been found on the initial DNN Azure Wizard 6.0 and the database user was not being created on the "CreateUser" step of the wizard. This step was marked as "completed" on the deployment step, but if you see on the "/logs/%dbadminuser%.roles.log"
file after the deployment, you will see SQL messages like this:
Msg 15247, Level 16, State 1, Server %servername%, Procedure sp_addrolemember, Line 51
User does not have permission to perform this action.
This is because the script was executed agains the "master" database instead the new DNN database. In order to fix this problem, download again the DNN Azure Accelerator package or:
1) Open the "/config/DeploymentTasks.xml" with the notepad.exe
2) Locate the "DeploymentTasks/Task3/Action/Parameters" node, and change the string "-d master" for "-d @@DBNAME@@"
3) Save the file
This error has been fixed in the actual available distribution package and the file is attached to this workitem.
Thanks to Joe Brinkman for finding this error.