Highlighted
Frequent Contributor.. Frequent Contributor..
Frequent Contributor..
150 views

PC 11.52 Database user credentials

As per HPs recommendation we need to have "Security Admin" privileges to install PC Database instance while installing PC ALM server. But we have a situation where the Database is managed by Database Team and they cannot allow our team to have "Security Admin" Privileges since it is as good as Database Administrator. This is security policy violation as per them. So, what is the way out? We have following issues because of this.

 

1. We cannot create PC DB instance while installing ALM server

2. We did create one instance after getting "Security Admin" privileges temporarily. Now we are not able to Analyze the results from PC 11.52. We cannot use the default MS access DB for analysis since our test results are too big and exceeds 1GB. So, we have tried to configure SQL Server option but because of privilege issue we are not able to configure that.

3. We cannot install SQL server express on all Controller/data processor to resolve this. This can only be a temporary solution.

 

Please let us know how to resolve this.

 

Thanks

Mohan

0 Likes
3 Replies
Highlighted
Trusted Contributor.
Trusted Contributor.

Re: PC 11.52 Database user credentials

Hi ,

Looking into your description , i'd suggest to submit an incident request via HP website ( please refer to http://support.openview.hp.com/casemanager/newincident ) .

We need to double check if there is any issue with your PC DB instance , it needs to be created during PC/ALM installation . Also , note that the limit for MS Access is 2 GB. When the result folder is larger than 2GB, MS Access may not work. SQL Server database can handle large result folders. Please refer to LoadRunner Analysis documentation on "Setting Database Options" in Chapter 2 on "Configuring Analysis" (Books online).
You can install SQL server (with license) or MSDE (desktop edition, no license). If single result files are larger than 2 GB, you will need full SQL server, as MSDE can only process less than 2GB file size.

Regards and thanks
Manu
0 Likes
Highlighted
Frequent Contributor.. Frequent Contributor..
Frequent Contributor..

Re: PC 11.52 Database user credentials

PC Database gets created during ALM installation only if you have "Security Admin" privilege to the Database. Otherwise it will throw an error during installation.

We have already tried SQL Server DB for analysis and that configuration works only if

you have "Security Admin" privilege to the SQL Server DB.

The issue is DB team cannot give that privilege and that is why I was looking for an alternate solution.

0 Likes
Highlighted
Respected Contributor.
Respected Contributor.

Re: PC 11.52 Database user credentials

Hi,

 

You should have the fowing Server Roles: dbcreator , securityadmin  for installation and later on for project's creation,  repair and upgrade.  It  part of the pre-requisits documented in ALM installation guide.

Aliza

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.