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...
>>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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment