2.16.2011

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:

http://www.techrepublic.com/blog/datacenter/changing-the-name-of-your-sql-server/192

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