Issue with removing project in ALM?

Question ID: 108484
0
0

Hello,
We are trying to test a newly installed install instance. We have created a test instance and added a new project and after we have concluded the testing we are trying to delete that project. Every attempt to delete the project we are seeing the following error: Failed to remove database of project ‘Datatest’.

What is recommended to get this project removed from our system…any hints, etc?

HomerJ

Marked as spam
Posted by (Questions: 314, Answers: 12)
Asked on July 11, 2018 2:23 pm
4 views
Answers (1)
1
Private answer

Hi HomerJ,
Everytime I have experienced this issue it has been the permissions and roles on the siteadmin user within the Database instance were incorrect. Adding the sysadmin role to that user within the DB has corrected this issue.

There is a knowledge article within the Microfocus support site if you have access to see this issue documented. The KM document is: KM03193336 The fix is noted as the following:

Grant the ''sysadmin'' role to the MSSQL 'admin' user.

For example, the 'admin' user in MSSQL is: ALM_ADMIN...
ALTER SERVER ROLE [sysadmin] ADD MEMBER [ALM_Admin]

Hope this helps,
Dan

Marked as spam
Posted by (Questions: 0, Answers: 709)
Answered on July 11, 2018 2:30 pm
Thanks for the assistance. Adding that roe corrected the issue.
( at July 11, 2018 2:32 pm)