Can access the DB but the users cannot log > Mitchel's Technical Forums

Mitchel's Forums

Subject: Can access the DB but the users cannot log

You are not authorized to post a reply.

Author

Messages

New Poster
Posts:4

04/10/2008 6:55 PM
Hi everyone this is my sad story, recently i finished my first DNN app and i started the deploy, i did it with a MSSQL 2005 DB but the server only have MSSQL 2000, so i used the publishing wizard to generate the whole script (structures and data), so i created a new DB in 2000 and made a bulk insert, but with another DB User. After i finished the deploy and all was reconfigured(new connection string) i started testing the site and it shows all the information fine, but when i tried to log in with the host user it always fail. Facts: I have connectivity with the database I create again the same user that i used before I saw the users table and the users looks fine Questions: Do the users of the DNN keeps a link with a DB User (For example its UID) Can i reset the password of the users in the database Thanks

Mitchel Sellers User is Offline

Site Admin/Owner
Guru

Guru
Posts:5595

04/11/2008 2:07 PM
DNN user accounts are maintained in two different places first the Users table, then also inside the aspnet_ tables. Make sure that your web.config files match each other with values for the machine keys (validation and decryption). If they don't match, update the new site to have the proper values and try again. Also, if you didn't bring the aspnet_ tables over, you will need to be sure that they migrate.

-Mitchel Sellers MCITP, MCPD, MCTS Director of Development IowaComputerGurus Inc. 3Essentials is my recommended Shared Hosting Provider This site is hosted on a VPS from HostMySIte.com Mosso is my recommended cloud computing provider. Use reference code REF-ICG to get $100 off your second month! To get Guaranteed DNN Support check out our affordable DNN Technical Support Programs

New Poster
Posts:4

04/23/2008 3:23 PM
Great, thank you very very much

You are not authorized to post a reply.

Forums >Development Discussion >DotNetNuke > Can access the DB but the users cannot log