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

Best Answer

  • DanCDanC Posts: 436 Gold 3
    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?

Answers

Sign In or Register to comment.