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

Doubling of Processors

I have been looking at a number of servers that have been installed in my
office lately. I know that these servers have 2 processors but when I look a
t
my SQL Server installations it shows that I have 4 processors on each of
these server. Is there something wrong with my installation or is this a
default behavior I don't understand.Hi,
Your server must be Hyper-Threading (HT) enabled.
See this link:-
QLonHTT.doc+hyper+threaded+sql+server&hl=en" target="_blank">http://64.233.167.104/search?q=cach...ql+server&hl=en
Thanks
Hari
SQL Server MVP
"GarrettD78" wrote:

> I have been looking at a number of servers that have been installed in my
> office lately. I know that these servers have 2 processors but when I look
at
> my SQL Server installations it shows that I have 4 processors on each of
> these server. Is there something wrong with my installation or is this a
> default behavior I don't understand.
>

Doubling of Processors

I have been looking at a number of servers that have been installed in my
office lately. I know that these servers have 2 processors but when I look at
my SQL Server installations it shows that I have 4 processors on each of
these server. Is there something wrong with my installation or is this a
default behavior I don't understand.Hi,
Your server must be Hyper-Threading (HT) enabled.
See this link:-
http://64.233.167.104/search?q=cache:LoRY2h6ZsfwJ:www.microsoft.com/sql/howtobuy/SQLonHTT.doc+hyper+threaded+sql+server&hl=en
Thanks
Hari
SQL Server MVP
"GarrettD78" wrote:
> I have been looking at a number of servers that have been installed in my
> office lately. I know that these servers have 2 processors but when I look at
> my SQL Server installations it shows that I have 4 processors on each of
> these server. Is there something wrong with my installation or is this a
> default behavior I don't understand.
>

Doubling of Processors

I have been looking at a number of servers that have been installed in my
office lately. I know that these servers have 2 processors but when I look at
my SQL Server installations it shows that I have 4 processors on each of
these server. Is there something wrong with my installation or is this a
default behavior I don't understand.
Hi,
Your server must be Hyper-Threading (HT) enabled.
See this link:-
http://64.233.167.104/search?q=cache...l+server&hl=en
Thanks
Hari
SQL Server MVP
"GarrettD78" wrote:

> I have been looking at a number of servers that have been installed in my
> office lately. I know that these servers have 2 processors but when I look at
> my SQL Server installations it shows that I have 4 processors on each of
> these server. Is there something wrong with my installation or is this a
> default behavior I don't understand.
>