SQL Adventures

I am assigned a project of upgrading Quality Center 9.2 to 11.0- and I decided to bring up a VM clone of the physical environment.  The issue arose that we needed to test patches applied to the VMs outside the isolated VM environment- and the VMs have duplicate names of the production systems- and are running SQL 2000 and SQL 2005...

I changed the names and IPs of the boxes and had to search a bit to find a way to get the SQL servers to behave with the new host names:


Additionally, if you lose the SA password, there are tricks where you can add an additional account to the SysAdmin group.

Now to re-configure the QC app to recognize the new DB location...

No comments:

Post a Comment