I known in SQL Server 2000 it's MS best practice to create database owner as
'sa'.
Is this still the case using SQL Server 2005?
I prefer to have sa as owner of the databases. That way, I have a known SID for the owner, and that
sid exists on any SQL Server I chose to restore that database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Joe P." <Joe P.@.discussions.microsoft.com> wrote in message
news:C564C628-DA50-41D7-9C5B-2982058BD226@.microsoft.com...
> I known in SQL Server 2000 it's MS best practice to create database owner as
> 'sa'.
> Is this still the case using SQL Server 2005?
>
|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uZ3Qkzz4GHA.4976@.TK2MSFTNGP06.phx.gbl...
>I prefer to have sa as owner of the databases. That way, I have a known SID
>for the owner, and that sid exists on any SQL Server I chose to restore
>that database.
>
Ditto. And the SA login should be disabled, even if you aren't running in
Windows Authentication mode.
David
|||And especially even if you ARE running in Windows Authentication mode.
;-)
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:u1A4d9z4GHA.1256@.TK2MSFTNGP04.phx.gbl...
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:uZ3Qkzz4GHA.4976@.TK2MSFTNGP06.phx.gbl...
> Ditto. And the SA login should be disabled, even if you aren't running in
> Windows Authentication mode.
>
> David
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment