April 9, 2014 at 8:42 am
I got an issue occured with my prod systems. I tried to open the properties of a database which gives error
"Cannot show requested dialog.
Additional information:
Cannot show requested dialog.(SqlMgmt)
Property Owner is not available for Database'[XXXX]'. This property may not exist for this
object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)"
As i knew this situatioin that Database owner property might not set and might showing "null" value.
I changed the owener to 'sa' using sp_changedbowner . After that there some issue occurs with app team.
At this moment i need some logs if available that what was the privious value of owner before i executed sp_changedbowner. Is there anywhere Database owner log is logged in sql server 2005.
PLz help me in this regard . Thanks in advance
April 9, 2014 at 9:49 am
sourav_1002001 (4/9/2014)
I got an issue occured with my prod systems. I tried to open the properties of a database which gives error"Cannot show requested dialog.
Additional information:
Cannot show requested dialog.(SqlMgmt)
Property Owner is not available for Database'[XXXX]'. This property may not exist for this
object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)"
As i knew this situatioin that Database owner property might not set and might showing "null" value.
I changed the owener to 'sa' using sp_changedbowner . After that there some issue occurs with app team.
At this moment i need some logs if available that what was the privious value of owner before i executed sp_changedbowner. Is there anywhere Database owner log is logged in sql server 2005.
PLz help me in this regard . Thanks in advance
I don't think that causes issues with the app. You can check it using your latest backup.
But why do you want to change it back ? That may again cause your previous issues.
Better thing is to investigate what's causing the actual issue instead of reverting it back.
--
SQLBuddy
April 9, 2014 at 10:16 am
Is there anywhere Database owner log is logged in sql server 2005.
sys.databases contains the owner of the db. That view is stored in the master db. If you have a backup of the master db from before you changed the user db owner, you can restore the master db to a different name and list who the owner was before.
Something like this:
RESTORE DATABASE master__restore
FROM DISK = '...\master.bak'
WITH MOVE '...' TO '...', MOVE ...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
April 9, 2014 at 2:38 pm
sourav_1002001 (4/9/2014)
I got an issue occured with my prod systems. I tried to open the properties of a database which gives error"Cannot show requested dialog.
Additional information:
Cannot show requested dialog.(SqlMgmt)
Property Owner is not available for Database'[XXXX]'. This property may not exist for this
object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)"
As i knew this situatioin that Database owner property might not set and might showing "null" value.
I changed the owener to 'sa' using sp_changedbowner . After that there some issue occurs with app team.
At this moment i need some logs if available that what was the privious value of owner before i executed sp_changedbowner. Is there anywhere Database owner log is logged in sql server 2005.
PLz help me in this regard . Thanks in advance
This typically happens when an account is set as the database owner and at some point afterwards the account is dropped from the server. Issues such as this can also occur when a user has a default database set and the database is then dropped, the user receives a login error.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply