Need guidance on updating DB String to point to DB using alias

  • Questions
  • Need guidance on updating DB String to point to DB using alias
Question ID: 107296
0
0

We are having an alias setup for our HP ALM DB and plan to update the DB Server connection string in HP ALM to point the DB using the alias (instead of changing the DB-Server name as well, we will leave it the same in ALM/QC)).

Will this connection string change (to alias) require us to re-run the configuration wizard? Or can I just update the "DB Servers" tab and then update the project connections string one by one?

Marked as spam
Posted by (Questions: 185, Answers: 13)
Asked on December 8, 2016 6:46 pm
4 views
Answers (1)
0
Private answer

Since you are only changing the connect string and NOT the DB-Server name as well, you need to do it in three ways/places:

1) In Site Admin/DB Servers tab, connection string for the dbserver.
Change the string and TEST it, then copy and put in a Notepad file so the string is EXACTLY what works, then use for #2 and 3 below.

2) Launch Configuration Wizard (indicate to ''keep all settings''), then step through to the DB Server tab and change your connection string -- you can edit it directly (paste from clipboard). Continue through and allow to re-deploy -- this will take some time and your ALM instance will be offline until deploy is finished.

3) Change the connection string for each project in Site Admin on it's Project details/information tab - link for editing the connection string.

3a) Also do this for the Lab_Project

-- if ALM-level license on the Lab Management tab

-- if Enterprise-level license see this post on how to expose Lab_Project:
http://eyeontesting.com/questions/11355/how-can-i-see-the-lab-project-within-site-admin.html

Marked as spam
Posted by (Questions: 3, Answers: 466)
Answered on December 8, 2016 6:56 pm