cannot show requested dialog

[Former Member]

hi,

when I logged( SA is the user) into microsoft sql server management tool and right click on database for properties following error is showing up. we got sql server 2005 sp1

Property Owner is not available for Database '[SLM]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

Any help will be appreciate

[Former Member]

Hi,

what happens when you log in Mangement Studio as <sid>adm? Please have a look at note 610640. A few more informations would be helpful.

Regards,

Sven

[Former Member]

Hi Sven,

Though I logged in as sidadm, I am having the same issue, i tried that script but was not useful.do you think what might be the reason?

Thanks,

Chander

[Former Member]

Hi Chander,

did you run the script with the repair option? It appears as if you have some security violation.

Run the SP sp_helplogins to find out which logins are valid in that db. It could look like that:

exec sp_helplogins 'sa' -- you don't have to specifiy the option 'sa'

And then you might want to change the owner of that db:

exec sp_changedbowner 'sa'

See also Books Online for the correct use of those SPs.

Regards,

Sven