Getting an error when I try to change the vCenter DB owner

[hux2000]

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!

[GreatWhiteTec]

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.

[GreatWhiteTec]

If this doesn't work, you may need to "juice up" your SQL box.

[hux2000]

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?

[hux2000]

Disabling the vCenter service enabled me to change the owner in the SQL Management Studio. Makes sense, I guess.