Forum


HomeHomePremiumPremiumAdministrationAdministrationFrom website to localFrom website to local
Previous
 
Next
New Post
4/25/2014 1:12 AM
 

Hi all,

Before upgradind to a new DNN version, I always make a copy (both the files and the database) and try it on my local computer.

I always have the same problem during that process after restoring the database as I can't just launch my website.

The SQL user account I created appears, as it should, under the main Security (Logins) folder AND under my database Security (Users) folder.

But it seems to have "lost the link" as when I go to  Security \ Logins under User mapping, the database is not checked.

It gets tricky when I try to establish the link again as I cannot just check the database because the user already exists under the database.

If I try to delete this user, I got an error as this user owns some ASP roles.

So I have change the owner of these roles, delete the user, add the user back, and change back the roles'owner...

What do I miss to make this much simpler ?

 
New Post
4/25/2014 4:17 AM
 

Hi Stephane,

I am no database expert but I never have this problem and I do that quite a lot (restore DBs on my local system).

I don't do anything special as far as I can see. I have the standard "sa" user as the owner of the databases and I use the same account (sa) on my local computer for all my databases.

Maybe not that helpful to you, but I wanted to describe what I do which doesn't cause problems and it is quite simple.

Cheers,

Aderson

 
Previous
 
Next
HomeHomePremiumPremiumAdministrationAdministrationFrom website to localFrom website to local



Try FREE
30 days money back guaranteed