Error during Quality Center 10 installation

  • Questions
  • Error during Quality Center 10 installation
Question ID: 104064
1
0

I’m getting an error when trying to install Quality Center 10:

Error
Installation failed due to an error creating the Site Administration database schema. Reason:

Failed SQL: /* ~~QC */ select * into ADMIN from qcsiteadmin_db.td.ADMIN [Mercury][SQLServer JDBC Driver][SQLServer]The server principal "td" is not able to access the database "qcsiteadmin_db" under the current security context.

Marked as spam
Posted by (Questions: 2, Answers: 434)
Asked on March 26, 2010 3:25 pm
29 views
Answers (4)
1
Private answer

Reset the td permissions in MS Sql Server. Execute the following statements in order, one at a time in MS Sql as a query:

exec sp_change_users_login 'Report'

exec sp_change_users_login 'Update_One','td,'td'

Marked as spam
Posted by (Questions: 15, Answers: 10)
Answered on March 26, 2010 3:30 pm
Related Link: http://eyeontesting.com/questions/5278/is-there-an-easy-way-to-switch-our-sql-server-qc-p.html
( at January 16, 2014 2:19 am)
1
Private answer

Actually what you are doing here, is mapping the existing database user 'td' to a SQL Server login called 'td'

ALTER USER 'td' WITH LOGIN = 'td'

could also be used

Marked as spam
Posted by (Questions: 6, Answers: 167)
Answered on March 31, 2010 2:50 pm
0
Private answer

error installation failed due to an error creating the site administration database schema. reason: failed SQl:/*~~qc*/create table qcsiteadmin_dbb.ADMIN as select * from qcsiteadmin_db.ADMIN [MERCURY][oracle jdbc DRIVER][ORACLE]ORA-01658:unable to create INITIAL extent for segment in tableSpace HPQC

Marked as spam
Posted by (Questions: 0, Answers: 2)
Answered on May 2, 2011 9:13 am
0
Private answer

error installation failed due to an error creating the site administration database schema. reason: failed SQl:/*~~qc*/create table qcsiteadmin_dbb.ADMIN as select * from qcsiteadmin_db.ADMIN [MERCURY][oracle jdbc DRIVER][ORACLE]ORA-01658:unable to create INITIAL extent for segment in tableSpace HPQC

Marked as spam
Posted by (Questions: 0, Answers: 2)
Answered on May 2, 2011 9:13 am