Wednesday, March 7, 2012

MSDE

Hi there,
I have a couple of questions related to MSDE 2000.
1. Is there only one SA account for all instances that may be present on a system or each instance has its own SA account and password?
2. When there is an MSDE instance already installed and it is set to Windows Authentication mode, are the instances installed later going to have to use Windows Authentication mode or they could be in Mixed mode?
Thank you for your help,
GDD1499
GDD1499,
Each instance of MSDE 2000 is completely independent and separate from all
other instances. So, to be specific, each instance of MSDE 2000 has its own
sa account and password. Additionally, one (or more) instances of MSDE 2000
can use Windows Authentication mode, while other instances on the same box
may be using Mixed Mode Authentication.
Chief Tenaya
"GDD1499" <anonymous@.discussions.microsoft.com> wrote in message
news:A38DA9C9-13F4-4C67-B911-74F24CD9D9DF@.microsoft.com...
> Hi there,
> I have a couple of questions related to MSDE 2000.
> 1. Is there only one SA account for all instances that may be present on a
system or each instance has its own SA account and password?
> 2. When there is an MSDE instance already installed and it is set to
Windows Authentication mode, are the instances installed later going to have
to use Windows Authentication mode or they could be in Mixed mode?
> Thank you for your help,
> GDD1499

No comments:

Post a Comment