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 |
|
venkath
Posting Yak Master
202 Posts |
 Posted - 2006-06-20 : 03:01:22
|
| Hi guys.,I have a restored a database and created a server login as user55when i am trying to create a database user with the same login as user55, i am getting the follwing error..Error-15023,User or role 'user55' alreay exists in the dbThis is a new database, no other logins were created...Thanks.. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-06-20 : 03:07:46
|
| but you just said you created a user55 after the restore, or do you mean, you've restored a db with a login user55?if yes, just drop the ol server login from the database, create then grantdbaccess againHTH--------------------keeping it simple... |
 |
|
|
venkath
Posting Yak Master
202 Posts |
Posted - 2006-06-20 : 03:18:04
|
| Yess, u r right,,Thanks. |
|
|
|
wilang
Starting Member
12 Posts |
Posted - 2009-08-12 : 05:02:54
|
| Hi,i have same problem with that.i am using sql server 2005 express.i login using windows authentication,and create new user,like dnnuser and uncheck enforce password policy , but it return error message same like aboveW |
|
|
|
|
|
|
|
|
Error-15023,User or role alreay exists in the db