SQL Change Automation - Visual Studio 2015 Project

Nirmal_Raisoni

Hi,

I am Visual Studio extension and creating baseline version from STAGING env. However whenever I am refreshing it's giving me error "The login already has an account under a different user name" so I used to skip using 
IF '$(IsShadowDeployment)' = 0 but whenever I am building a database In Jenkin (Contineous Integration) server, its always throwing me an error Can't able to connect 

Any help appreciated?

Thanks,
Nirmal 

Sergio R

Hi Nirmal,

This is caused by a CREATE USER statement on one of your migration scripts.

It looks like that when it attempts to build the Shadow Database it encounters this error because the login is already linked to a different user.

Regarding the other error it looks like the build agent you are using is unable to connect to a SQL instance, without looking at the log we are unable to to provide more details.

Kind Regards,