vCenter 5 + MSSQL 2008 R2. I'm trying to change the vCenter database owner by going into the SQL Server Management Studio, right-clicking the vCenter db, choosing properties, then "Files", then updating the "Owner" field. However, when I do this I get the following error:
"Lock request timeout period exceeded. (Microsoft SQL Server, Error: 1222)"
Any idea what's going on here and how I can fix it?
Needless to say, I am in no was a db admin!
From Management studio, click on your DB and create a new query.
sp_who2 and execute
this will return a list of processes running. Look for the Blk By column to see what process is being blocked. You can kill the process by runnign
kill <SPID> if you feel it is ok to terminate that process.
Hope this helps.
If this doesn't work, you may need to "juice up" your SQL box.
The "Blk By" column is completely empty. Also, it's not a SQL box performance issue: the stats show a consistent CPU usage of around 3%, RAM around 15%, network bandwidth almost never above 100KB/sec, etc.
Do I need to shutdown the vCenter box before trying to change the DB owner? If you don't technically need to, would it help if I did?
Disabling the vCenter service enabled me to change the owner in the SQL Management Studio. Makes sense, I guess.