sql compare deploy always errors on users

Comments

• LtMandella Posts: 8

  June 27, 2017 6:23PM

  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".
  

  0 · Share on Twitter
• Mark J Redgate › Posts: 125 Bronze 5

  June 28, 2017 9:42AM

  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,

  0 · Share on Twitter
• LtMandella Posts: 8

  June 28, 2017 6:38PM

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

  0 · Share on Twitter