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
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.