How can we help you today? How can we help you today?

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.
audiadventure
0

Comments

4 comments

Sort by
  • DanC
    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.
    DanC
    0
  • audiadventure
    Thanks DanC, would this be necessary every time credentials change.  As this would be painful!
    audiadventure
    0
  • DanC
    Hi @audiadventure

    You're welcome!

    I'm not sure, I don't think this would be the case, but I'm going to double-check with the developers!
    DanC
    0
  • DanC
    Hi @audiadventure

    Could I ask for a bit more info?

    Is this an authentication token failure? if so, the TTL could be measured in minutes, whereas if it's the AD credentials, that should be much less often.
    DanC
    0

Add comment

Please sign in to leave a comment.