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

The login already has an account under a different user name

sql server – The login already has an account under a different user name – Database Administrators Stack Exchange

Feb 22, 2013 — In SSMS Go to Security / Logins, select the user in question. · Select User Mappings. · In the User Column, just rename it properly for each …

Login already has an account under a different user name

Login Failed – Login already has an account under a different user name – SQLServerCentral Forums

Right Click – New User – Enter User Name, Login Name, Assign Roles, OK. … The login already has an account under a different user name.

Login Failed – Login already has an account under a different user name Forum – Learn more on SQLServerCentral

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

The login already has an account under a different user name. (Microsoft SQL Server, Error: 15063)

Try going to Security…Logins at the server level. Double click on login LTAdmin. Under user mapping, click on database yyy, and change the …

Getting “The login already has an account under a different …

Getting “The login already has an account under a different user name” when trying to map a user to a SQL Login – Microsoft Q&A

Dec 5, 2022 — I have a SQL Login on an Azure SQL server for a particular user account called “azsqlreleaseadmin”. I try to map this login into a new …

I have a SQL Login on an Azure SQL server for a particular user account called "azsqlreleaseadmin". I try to map this login into a new database user. The database has been released to the environment using ADO and a dacpac file. The dacpac file contains no definition of the azsqlreleaseadmin user, I want to add it after. So tried to run:

CREATE USER azsqlreleaseadmin FOR LOGIN azsqlreleaseadmin

As far as I can see, this should work, but I get the error:
Msg 15063, Level 16, State 1, Line 22
The login already has an account under a different user name.

I also tried using a different username to check if it was a naming issue:

CREATE USER azsqlreleaseadmin2 FOR LOGIN azsqlreleaseadmin

Same result.

I ran this to check if the user exists:

select * from sys.database_principals where type=’U’ or type = ‘S’

Which did not return the user. When running this on the master database, I see the login:
SELECT * FROM sys.sql_logins

I ran this to try and delete the user on the database.
DROP USER azsqlreleaseadmin

Which returns:
Cannot drop the user ‘azsqlreleaseadmin’, because it does not exist or you do not have permission.

I am using the Server Admin account, so definitely have permission. I also mapped the server Admin account as a new user, which worked fine.

I have looked through a dozen stack overflow and old MSDN resolutions, they all suggest the user exists on the database. But clearly it doesn’t according to the above query.

It seems like there is some sort of problem mapping creating SQL Users on Azure SQL databases from Logins? I did this a few months ago without issues.

Copy Database Workaround for “The login already has an …

Copy Database Workaround for “The login already has an account under a different username” | Tech Tips

Nov 18, 2016 — I ran across the error “the login already has an account under a different username” while trying to copy a database from one server to …

The login already has an account under a different user name

Database Creation Error: The login already has an account under a different user name

Administrators encounter an error when creating a new database for Workspace Environment Management, if they use the same account as the Broker Service …

Administrators encounter an error when creating a new database for Workspace Environment Management, if they use the same account as the Broker Service Account.

this login already has an account under different user name …

this login already has an account under different user name during Build phase — Redgate forums

The login already has an account under a different user name. RedGate.Versioning.Automation.Shared.Errors.TerminatingException: Schema …

Successfully created and built SQL Change Automation project. Database  has number of users  assigned to the roles.

“The login already has an account under a different user name …

“The login already has an account under a different user name.” – MSSQL « The Wiert Corner – irregular stream of stuff

Jul 11, 2018 — You get “The login already has an account under a different user name.” when you try to create a user that already exists.

You get “The login already has an account under a different user name.” when you try to create a user that already exists. In this case it was a statement somewhere in a database creation script having a statement like this: exec sp_addlogin N’<>’, N’<>’, @logonDatabase, @logonLanguage What happened was that the <> in the script already existed…

Adding SQL Login does not work – Stack Overflow

sql server – Adding SQL Login does not work – Stack Overflow

Nov 3, 2013 — Msg 15063, Level 16, State 1, Line 1 The login already has an account under a different user name. Here is my connection string: “Data Source= …

Cannot create database ‘AzureStorageEmulatorDb56 … – GitHub

Cannot create database ‘AzureStorageEmulatorDb56’ : The login already has an account under a different user name. · Issue #742 · Azure/azure-storage-net · GitHub

Jul 23, 2018 — Cannot create database ‘AzureStorageEmulatorDb56’ : The login already has an account under a different user name. Changed database context to ‘ …

I have upgraded the Azure Storage Emulator from 5.4 to 5.6 and have 3 db’s on my localDB: AzureStorageEmulatorDb45 AzureStorageEmulatorDb54 AzureStorageEmulatorDb56 I have ran start, init and found the /forceCreate flag in the docs. Here…

Keywords: the login already has an account under a different user name.