Did you try to change the password in ALM side? Site admin->Site projects tab->domain_name->project_name select "DB user Password" link under Project details tab.

I have tried resetting the password everywhere that I can think of or find. Even when I setup a new domain and try and create a project, I get the below.

On checking the SQL logs, it gives the same message ""Login failed for user 'td'. Reason: Password did not match that for the login provided.". "

I have tried going in seeing what happens if I try and repair a project, I get "Can not access database of project. Abort task". and if I check the SQL logs it shows " ""Login failed for user 'td'. Reason: Password did not match that for the login provided.". ""

It seems all the issues stem around this TD account

Sorry one last thing is. On the DB servers tab I have two database servers. The new and the old. I point ed the old one to the new connection string the ping to both of them work

Please log a support case if you can and give me the id, which can help us trouble shoot more quickly. 

You can do the following to do further investigation:

1. create a new project on the same database as the project with problem and i hope there is no issue on this project
2. go to the projects table in the SA schema, there are projects connection string and DB user/schema password(hashed), in which you can easily tell the diff between normal projects and problematic projects. 

let me know your findings. 

Check on the sql server and see if there is a user called "td". 

I guess there is already a login called "td" in your database. You will need the credentail for that login to continue.

There is a td user and thew password has been reset on that account too.

What are the exact locations where the password needs to be set for this account on the ALM application server? I see a lot of mentions of a siteadmin xml file and I feel that I might be missing setting the password in one of them.

There is a td user and thew password has been reset on that account too.

What are the exact locations where the password needs to be set for this account on the ALM application server? I see a lot of mentions of a siteadmin xml file and I feel that I might be missing setting the password in one of them.