sql compare deploy always errors on users

• 
  clarification: Sqlcompare deployment error says "the login already has an account under different name". But if don't checkmark the user account for deployment, the deployment fails saying "user does not exist".
  

  LtMandella June 27, 2017 18:23

  - 0 +
• 
  Hi - sorry to hear you're having problems with SQL Compare
  
  If I understand the problem correctly, near the top of the deployment script there should be some lines like this: (when the user is selected)
  

  IF NOT EXISTS (SELECT * FROM master.dbo.syslogins WHERE loginname = N'loginX')
  CREATE LOGIN [loginX] WITH PASSWORD = 'p@ssw0rd'
  GO
  CREATE USER [userX] FOR LOGIN [loginX]
  

  
  It sounds like the login already exists, so the CREATE LOGIN statement isn't running, but the CREATE USER statement is failing because the login is already assigned to a different user. I think the thing to do is to find this other user that the login is assigned to and deploy that one first, so that the login is freed up to be assigned to the user that you want to deploy.
  
  Hope that's helpful,

  Mark J June 28, 2017 09:42

  - 0 +
• 
  Yes sir I believe you understand the issue despite my muddy description. I will give your suggestion a try, thank you.
  

  LtMandella June 28, 2017 18:38

  - 0 +

Add comment

Please sign in to leave a comment.