troubleshooting Question

Scheme login already exists

Avatar of Kyliem
Kyliem asked on
Microsoft SQL Server
3 Comments1 Solution714 ViewsLast Modified:
MS SQL Server 2005

Hi, I have a general query thats bugging me.  I have some demo databses setup and have the usual 'scheme' user assigned etc which is fine and works great.  

However, I have restored a customer databse (lets call it db1) and it seems the user 'scheme' does not have access to it.  ie, No login exists for scheme against it.  I goto 'logins'', select scheme and then 'databse access tab'.  I tick the customer databse as access allowed and specify the login as user 'scheme'.  However, it argues that user scheme already exists and will not allow me to add it.  

The error I get is "Error 21002" [SQL-DMO] user 'scheme'a ready exists.

So I am stuck in a loop, no databse login scheme exists for my databse db1 but if I try adding it then I get error.  As this is a restored databse do I have a user ID mismatch between their server and mine?

I am just trying to understand the logic and reasoning here so no urgency.  Many thanks

Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 1 Answer and 3 Comments.
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>


Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 1 Answer and 3 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004