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...Using Modules a...Using Modules a...User registration problemsUser registration problems
Previous
 
Next
New Post
10/21/2013 7:40 AM
 

You have to check on the database, not on the Server.  Open the database/Security/users/ tab and open advanced Settings of the dbo, check if sa is mapped to the Login Name.  I think the Login Name is missing.

After restore a database to an SQL Server the LOgin Names can not be mapped about all users have a different SID.

 
New Post
10/21/2013 8:31 AM
 
I just checked and it appears as though the sa user is not mapped to my DNN database. I have tried to add it with different role memberships and I keep hitting an error saying: "Cannot use the special principal 'sa'. (Microsoft SQL Server, Error:15405)". Thanks for the help so far! It looks like we're getting somewhere slowly :)
 
New Post
10/21/2013 10:05 AM
 

Login on SQL Management Studio and open a new Query page.  Then run following script after you changed with your database Name:

/*** Start Script ***/

use database

Go

exec sp_change_user_login 'Update_One', 'dbo', 'sa'

Go

/*** End Script ***/

If you have a other user Name on your Connection strings search also about that username on the database and then run same script as above after Change the dbo with the username of the database and the sa with the Login Name of the SQL Server security.

Sample:

/*** Start Script ***/

use database

Go

exec sp_change_user_login 'Update_One', 'dbuser', 'dbusername'

Go

/*** End Script ***/

 
New Post
10/21/2013 10:16 AM
 
Please notice:  this is the issue I posted already on page 2 of this thread. :-D  You will see it on the script samples.
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Using Modules a...Using Modules a...User registration problemsUser registration problems


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