December 28, 2006 at 1:12 pm
Hello
i am just getting familiar with sql. I went in EM and created a test db.
I was logged in with my win2003 domain id. When i went into properties of the db i expected to see owner - my domain id
instead it shows 'system'
I'm a lil confused - why does it show system?
December 28, 2006 at 2:21 pm
If u created db after logging in as a domain user.. it must show the domain account as the db owner. So may be the db u r referring is created by some SQL account name system ? [Just wondering of the reason]
Otherwise, if there is a system account then is it possible that the ownership is changed to that a/c by some one else?
Regards
Utsab Chattopadhyay
December 28, 2006 at 2:27 pm
no one else uses my pc. and i am just playing around to get familiar.
is system a built-in account in sql?
December 29, 2006 at 6:51 am
Although you posted in a SQL Server 2005 forum, you mentioned you used Enterprise Manager. Are you using SQL Server 2005 or SQL Server 2000?
Anyway, the Windows SYSTEM account is similar to the local administrator account, except that it is used internally by Windows and not for users to log in with.
See http://support.microsoft.com/kb/120929
When you look at the login id's in SQL Server, you will notice NT Authority/SYSTEM. That is the Windows SYSTEM account, and is also the LocalSystem account.
I'm not sure how that account was assigned ownership of the database, however. Did you try using the sp_changedbowner stored procedure?
December 29, 2006 at 11:19 am
thx for your responses
before i try to change owner i'd like to understand what's going on
i am using sql 2000
December 29, 2006 at 11:35 am
I'm not sure what happened - I've never seen that before.
Can you create another database, and then check the owner in the database properties?
Are you use MSDE on a desktop or workstation, or are you using the Standard Edition or higher on a server?
December 29, 2006 at 11:35 am
ok i just noticed something.
First, "system" seems to be a login associated with our portfolio mgmt software which runs on top of sql.
When i checked my local sql server registration properties, it was set to use sql server authentication with the system login.
I went ahead and changed it to windows authentication.
i then created a test db and checked its properties and now, i see my domain (windows) id.
So, i'm guessing that when one uses SQL authentication in server registration, the specified ID takes over ownership of a created db?
December 29, 2006 at 11:38 am
Yes, whatever login id is used to register the server in EM will be the owner of any objects created in EM.
December 29, 2006 at 11:40 am
I just created another test db - i see my domain\user listed - as i would expect
We have sql 2000 on our server but on my pc i am running sql 2000 personal sp4
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply