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 |
|
sg2255551
Constraint Violating Yak Guru
274 Posts |
 Posted - 2010-09-10 : 02:14:37
|
| hihere sa account is enabled.I have a user called DBuser and has place him under DBOwner of a DB. No problem, i can login to my web apps.later i create a new account called serveruser with sysadmin role. i have mapped him all system db, and i now disabled the sa account.I am not able to login to my web apps anymore. It says sa account has been disabled.Why is that so and how should i solve this? Thanks |
|
|
sg2255551
Constraint Violating Yak Guru
274 Posts |
Posted - 2010-09-10 : 02:44:49
|
| ok, i have managed to solve this. It is because of the ASPState DB. Thanks |
 |
|
|
|
|
|
new sql user with sysadmin role.