Error during Quality Center 10 installation
| ♥ 0 |
I’m getting an error when trying to install Quality Center 10: Error 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 |
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 young-steve (Questions: 15, Answers: 10) Answered on March 26, 2010 3:30 pm
|
|||
|
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 Captain Mercury (Questions: 6, Answers: 167) Answered on March 31, 2010 2:50 pm
|
|||
|
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 surendra (Questions: 0, Answers: 2) Answered on May 2, 2011 9:13 am
|
|||
|
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 surendra (Questions: 0, Answers: 2) Answered on May 2, 2011 9:13 am
|