Geting error ”Failed to Restore Project. Database server does not exist”

  • Questions
  • Geting error ''Failed to Restore Project. Database server does not exist''
Question ID: 107486
0
0

I am trying to restore two different projects but they are failing to restore. For one of them, it is saying "Database server does not exist" and for the other one, it is saying, "Failed to Restore Project."

Marked as spam
Posted by (Questions: 91, Answers: 6)
Asked on March 2, 2017 11:48 pm
7 views
Answers (1)
0
Private answer

This situation could be caused by a few problems:

1) Check that the database indicated in the DBID.xml actually exists in the specified database server AND that you can login/access it with the ''td'' user or Win-auth user (SQL-Server) or in Oracle the schema/user with the same name as the project database (schema).

2) Make sure (with a sample working project's DBID.XML file) that the DB Connect string and DB-Server name are correct

3) Generally, when using SQL-Server with SQL-Server-Authentication, or Oracle, the password is the same for all of the QC schemas/databases. There is an encnryped password string in the DBID.xml file for the project - check it against a working project's DBID.xml file.

4) Check the project repository folder indicated in the DBID.xml file. does it exist?

5) if using SQL-Server with SQL-Server-authentication, AND the project DB was RESTORED into SQL-Server from backup, did the DBA run the sp_change_users_Login command to ''fix'' the ''td'' user?

http://eyeontesting.com/questions/6548/question-about-db-restore-and-the-roleuse-of-the-t.html

Marked as spam
Posted by (Questions: 3, Answers: 466)
Answered on March 2, 2017 11:58 pm
Thanks, we had a misspelled DB-Server value
( at March 3, 2017 12:00 am)