December 17, 2010 at 2:19 pm
I have been assigned a database to support. The Database Owner column of this database is empty but under General database properties, The Owner of the database is, NT AUTHORITY\SYSTEM.
Confusion? Any knowledge sharing is appreciated.
+ive
December 17, 2010 at 2:30 pm
In addition, if I look at user mapping for user NT AUTHORITY\SYSTEM, the user mapping is empty.
+ive
December 17, 2010 at 3:55 pm
jeelanik (12/17/2010)
In addition, if I look at user mapping for user NT AUTHORITY\SYSTEM, the user mapping is empty.+ive
If by empty you mean there are no user databases checked for the account, try checking the server permissions. If the account is sysadmin or maybe dbowner it will not necessarily be mapped to a username for the database.
I have seen it before where the GUI properties window and system views do not match. Just try re-assigning the owner of the DB to see if they will match up then.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
December 20, 2010 at 8:14 am
The security permissions on the server login for the user shows no user mapping to the databases in question.
So, just a recap. When I right click on the database and under general properties their is Owner property under Database and it lists as NT AUTHORITY\SYSTEM
However, when I click on Files property, the property Owner is empty and the property User full-text indexing is clicked but grayed out, i.e, I cannot change Use full-text indexing property.
Thank you.
+ive
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply