MS SQL Error "Property owner is not available"

Plesk Servers > SQL > MSSQL

 

MS SQL Error "Property owner is not available"

Issue 
When trying to access properties for a database in Microsoft SQL Server Management Studio, you get the following error: 
 
Microsoft SQL Server Management Studio  
Cannot show requested dialog. 
ADDITIONAL INFORMATION: Cannot show requested dialog. (SqlMgmt) Property Owner is not available for Database '[databasename]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.  (Microsoft.SqlServer.Smo)

Cause
Owner of the selected database is set to a user other than the sa user.

Solution
  1. Click on the New Query button
  2. Copy the following script into the New Query box replacing [databasename] with the name of the database you are working with.
    use [databasename]
    EXEC sp_changedbowner 'sa'
  3. Click Execute

 

Add Feedback