Migrated ALM Azure to On-prem

Hello,

I am running ALM Version 15.00.857. This has been migrated from Azure in the last few weeks.

I have restored the DBs and I can access the siteadmin portal.

I have having an issue with getting access into the projects and domains. The main issue seems to be SQL access. We are increasingly hitting a brick wall when we try and ping or edit the connection string on any of the projects, this being the error - "Login failed for user 'td'. Reason: Password did not match that for the login provided.". We have tried resetting passwords etc, but this is the error we always get.

In DB Servers the "ping finished successfully" message is OK on the database string.

I am at a complete loss with this, we have inherited this application and it's a best endeavors at the moment to get it up and running.

Any pointers would be great on where exactly I can start to try and get this resolved

Tags:

Parents Reply Children
  • 0   in reply to 

    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. 

  • 0   in reply to 

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