SQL Change Automation - Visual Studio 2015 Project

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 
Tagged:

Best Answer

  • Sergio RSergio R Posts: 576 Rose Gold 5
    Accepted Answer
    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,
    Sergio
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
Sign In or Register to comment.