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
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
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 >>
Mike
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
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.