Roger Wolter[MSFT] wrote:
> Right click on the server in the explorer window of SSMS, select the
> security tab, and there should be a radio button to select windows or mixed
> security.
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
> <theitfella@hotmail.com> wrote in message
> news:1157730915.673449.179400@e3g2000cwe.googlegro ups.com...
> > Hi there
> >
> > newbie quick question - we have already configured sql 2005 to use only
> > windows authentication during setup. Now we would like to also use the
> > SA account like in mixed mode authentication or even SA only.
> >
> > What is the easiest way of doing that?
> >
> > Thanks
> >
> > Tony
> >

Thanks for the reply, the solution worked for me. I didn't realise I
had to justify my requirements Arnie but thanks for the advice anyway.

Not a question of having to "justify my requirements".

Your post started off with " newbie quick question", and then proceeded to
ask a question that deals with a significant mistake often made by
'newbies'. I tried to offer a rational about why that was a mistake, and
then entreated you to allow us to you derive a better solution.

However, from your curt retort, I now assume that your 'newbie-ness' was
perhaps not completely accurate, and that you were offended by my attempt to
you.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


<theitfella@hotmail.com> wrote in message
news:1157909478.441994.17340@m73g2000cwd.googlegro ups.com...
>
> Roger Wolter[MSFT] wrote:
>> Right click on the server in the explorer window of SSMS, select the
>> security tab, and there should be a radio button to select windows or
>> mixed
>> security.
>>
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> Use of included script samples are subject to the terms specified at
>> http://www.microsoft.com/info/cpyright.htm
>>
>> <theitfella@hotmail.com> wrote in message
>> news:1157730915.673449.179400@e3g2000cwe.googlegro ups.com...
>> > Hi there
>> >
>> > newbie quick question - we have already configured sql 2005 to use only
>> > windows authentication during setup. Now we would like to also use the
>> > SA account like in mixed mode authentication or even SA only.
>> >
>> > What is the easiest way of doing that?
>> >
>> > Thanks
>> >
>> > Tony
>> >
>
> Thanks for the reply, the solution worked for me. I didn't realise I
> had to justify my requirements Arnie but thanks for the advice anyway.
>

Arnie,

Not at all offended just slightly suprised. You're reply was probably
the right one and I thank you for your effort, really. Now I'm even
feeling guilty!

And I don't know what curt retort means, but I can guess.

Thanks again

Tino