LoadRunner Enterprise SQL Database Sever Sysadmin Privileges

Question ID: 109849
0
0

Our team is getting ready to install LoadRunner Enterprise 2020 SP2.  We are planning to use SQL.  I’m being told that the sysadmin cannot have access rights to create SQL databases. If it is required, they may grant elevated privileges.  Does anyone know if this be an issue? Any help would be great.

 

Marked as spam
Posted by (Questions: 151, Answers: 15)
Asked on September 25, 2020 8:44 am
8 views
Answers (1)
0
Private answer

Micro Focus states the following prerequisites for SQL:

"To connect, LoadRunner Enterprise to a Microsoft SQL database server, the installing database user must have sufficient permissions to perform certain administrative tasks in SQL.

For SQL Authentication you need to have two user accounts in the SQL database:

  • LRE database admin account: A user with "dbcreator" permissions is required
  • LRE database user account: A user with "public" permissions is required
    • If you are upgrading from a previous version, use the same user account defined in your previous version.

For more information please see the link below:

https://admhelp.microfocus.com/pc/en/2020.2.0/pdfs/PC_Install.pdf

I hope this helps

Marked as spam
Posted by (Questions: 17, Answers: 257)
Answered on September 25, 2020 8:46 am