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

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros