Doubling up security on SQL Server system administrator

Hi All
Always baffled me this, but although I can set up complex SQL usernames and
passwords for my SQL database the main system administrator login details
only give me half the security because the username is always 'sa'. I can
only set a complex password for the most powerful user of them all.
This might be a very newbie question, but is it possible (and advisable -
knowing Microsoft's progs don't like changing core settings after the event)
to change the system admin's username to something else?
Please note that I already have a number of databases running on this SQL
server installation so would this implicate their use if I changed it?
Rgds
RobbieSee reply in .setup
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Astra" <info@.NoEmail.com> wrote in message
news:eqYQsd%239EHA.2680@.TK2MSFTNGP09.phx.gbl...
> Hi All
> Always baffled me this, but although I can set up complex SQL usernames
> and
> passwords for my SQL database the main system administrator login details
> only give me half the security because the username is always 'sa'. I can
> only set a complex password for the most powerful user of them all.
> This might be a very newbie question, but is it possible (and advisable -
> knowing Microsoft's progs don't like changing core settings after the
> event)
> to change the system admin's username to something else?
> Please note that I already have a number of databases running on this SQL
> server installation so would this implicate their use if I changed it?
> Rgds
> Robbie
>|||Robbie,
Did you ever get the answer to this? I want to do the same as you -
how do I do it?
Darren.
Astra wrote:
> *Hi All
> Always baffled me this, but although I can set up complex SQL
> usernames and
> passwords for my SQL database the main system administrator login
> details
> only give me half the security because the username is always 'sa'.
> I can
> only set a complex password for the most powerful user of them all.
> This might be a very newbie question, but is it possible (and
> advisable -
> knowing Microsoft's progs don't like changing core settings after the
> event)
> to change the system admin's username to something else?
> Please note that I already have a number of databases running on this
> SQL
> server installation so would this implicate their use if I changed
> it?
> Rgds
> Robbie *
railex
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message1342852.html