Unable to move WSUS 3.0 database due to insufficient permissions to drop connections
I need to move the wsus database from one drive to another.
I understand the instructions given at the three sources given below. My problem is that when I try to execute the "detach database" from within Studio, I get the message "The user does not have permission to perform this action. (Microsoft SQL Server, Error: 297")
I am connected to studio as the same administrative user that did the install of SBS 2008. I understand that this should be a simple manual change to permissions but I want to do it correctly and I'm not sure what permissions are needed or if I ought to connect differently.