How can I re-open an existing project?

audiadventure

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.

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. 

audiadventure

Thanks DanC, would this be necessary every time credentials change.  As this would be painful!

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

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.