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 [email protected] in Active Directory (Authentication=ActiveDirectoryPassword).
Error code 0xparsing_wstrust_response_failed
Federated service at returned error: ID3242: The security token could not be authenticated or authorized.

Is there anyway to recover this project for editing.

Best Answer

  • DanCDanC Posts: 552 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.