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.

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s





%d bloggers like this: