What are the challenges you face when working across database platforms? Take the survey

SQL Change Automation - Visual Studio 2015 Project


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?


Best Answer

  • Options
    Sergio RSergio R Posts: 610 Rose Gold 5
    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,
    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.