Cannot Add a Sql Server Login

Question :

Cannot Add a Sql Server Login,

Answer :

When I try to create a SQL Server Login by saying

CREATE LOGIN [ourdomainSQLAccessGroup] FROM WINDOWS;  

I get this error

The server principal ‘ourdomainSQLAccessGroup’ already exists.

However, when I try this code

DROP LOGIN [ourdomainSQLAccessGroup]  

I get this error

Cannot drop the login ‘ourdomainSQLAccessGroup’, because it does not exist or you do not have permission.

The user that I am executing this code as is a sysadmin. Additionally, the user ourdomainSQLAccessGroup does not show up in this query

select * from sys.server_principals  

Does anyone have any ideas?

Read More  My VMware ESX server console volume went readonly. How can I save my VMs?

,

We are still struggling to understand the HOW of this issue, but it seems that [ourdomainSQLAccessGroup] was aliased by a consultant to a different user name (this is part of an MS CRM installation). We finally were able to use some logic and some good old SID comparisons to determine who was playing the imposter game.

Our hint came when I tried to add the login as a user to the database (since it supposedly already existed) and got this error:

The login already has an account under a different user name.  

So, I started to examine each DB user and was able to figure out the culprit. I eventually tracked it down and was able to rename the user and login so that the CRM install would work. I wonder if I can bill them $165.00 an hour for my time… 🙂

Read More  Any restrictions on development in Vista

That’s the answer Cannot Add a Sql Server Login, Hope this helps those looking for an answer. Then we suggest to do a search for the next question and find the answer only on our site.

Disclaimer :

The answers provided above are only to be used to guide the learning process. The questions above are open-ended questions, meaning that many answers are not fixed as above. I hope this article can be useful, Thank you