February 10, 2012 at 4:15 pm
When I install SQL server 2008 R2, I didn't see there is a screen ask for me to create a SA account.
I guess maybe I chose the windows authentication mode.
After installation, I see sa is there in security. and it is disabled.
Do I need to make a password for it?
Thanks
February 10, 2012 at 4:21 pm
During the install you will be asked if you want to install Windows or Mixed Mode. If you go with mixed mode you have to specify an SA account to continue.
It looks like you are running in Windows mode. You can certainly enable the SA account and specify a password for it, however you will not be able to use it until such time as you change SQL to run in Mixed Mode for authentication and restart the services.
February 10, 2012 at 4:24 pm
Thank you, I do use windows mode for now.
Another question related with this, even sa account is disabled, I can still change a db owner to sa from a person that has left our office, correct?
And I also can assign to sa as a job owner even the account is disabled, correct?
Thanks
February 10, 2012 at 4:35 pm
Correct.
If you query sys.databases you'll see that the owner of the master, model, msdb and tempdb databases are already SA.
SELECT NAME, SUSER_SNAME(owner_sid) FROM sys.databases
February 10, 2012 at 4:36 pm
Thank you!
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply