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

How can I re-open an existing project?

When I want to open an existing SQL Change Automation project, I get an error stating:
Error connecting to database: Failed to authenticate the user xxxxxx.xxxxxxx@xxxxxxx.co in Active Directory (Authentication=ActiveDirectoryPassword).
Error code 0xparsing_wstrust_response_failed
Federated service at https://adfs.ricoh-europe.com/adfs/services/trust/2005/usernamemixed returned error: ID3242: The security token could not be authenticated or authorized.

Is there anyway to recover this project for editing.

Best Answer

  • Options
    DanCDanC Posts: 609 Gold 4
    Hi @audiadventure

    I suspect this is due to it trying to connect to the existing target with your credentials and so in this case what you can do is remove the "TargetConnectionString" property from the .sqlproj.user file before opening the project. From there you can set the development DB when prompted. 

    Kind regards

    Dan Calver | Redgate Software
    Have you visited our 
    Help Center?


Sign In or Register to comment.