SQL Server Error 15063

I kept getting a SQL Server error 15063, “This login already has an account under a different username”, when trying to add an Active Directory account as a user in a particular database. I didn’t realize it, but a previous admin had mapped the dbo username to that login. Strange. To find the offending account, I opened a new query window and ran:

sp_helplogins 'domain\account'

Hope this can help someone out.


0 Responses to “SQL Server Error 15063”

  1. Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

TwitterCounter for @anthonyrstevens
Add to Technorati Favorites

RSS Feed

View Anthony Stevens's profile on LinkedIn

%d bloggers like this: