Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BellaScout
Starting Member
25 Posts |
 Posted - 2009-02-19 : 15:49:08
|
| Everything was working well until I tried to move the database and website. I tried clearing all the role provider tables and re-establishing the users/roles using the asp.net website administration tool but the tables are not getting populated with values. The app runs fne within vs 2008 but within IIS I cannot log on. How do I get the roles/users back into sql server tables? I tried re-running aspnet_regsql and removed/added back all users and roles but still the tables are not getting populated and I cannot log on through IIS. Please Help! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
BellaScout
Starting Member
25 Posts |
Posted - 2009-02-19 : 16:06:27
|
| yes, but when I moved the database over and the web app, it would not let me logon from IIS...so I cleared all the aspnet tables and tried to recreate the users and roles (deleted and then added back using the website config tool). This kinda tells me that it wasn't working from the beginning after I moved it. (could not logon). |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
BellaScout
Starting Member
25 Posts |
Posted - 2009-02-19 : 17:16:34
|
| I think I found my problem. An application user was created but has wrong privileges. I need to remove a user but cannot do it. How do you simply drop a user? I dropped the logon from the database but cannot delete the user from the database. Error is "The database principal owns a database role and cannot be dropped". Where/how can I just drop this user? Is there a sp I can run that drops it? |
|
|
|
|
|
|
aspnet role/membership provider problem