Hiya Josh ---

Makes sense to me. When I replied I forgot about Win 9x. After all, before 7.0 SQL Server was not an option on those platforms :-D

Thanks to you and Jim N. for the clarification.

>
>Actually, as I read it MSDE can use either standard or integrated security. The limitation is that it can't use integrated security when running on Windows 9x.
>
>>Craig ---
>>
>>SQL Server has two types of security, I forget the exact terms, one where SQL Server handles it and another where it's reliant on NT security (integrated security). I'm interpreting this to mean that MSDE only supports integrated, which for the most part is fine as this is what most people use anyway.
>>
>>>>>Limitations as to performance and users is what I was referring to. I realize that MSDE is SQL Server...just many of the things that make SQL Server great, like simultaneous users, scalability, etc. are not available. Am I also correct that MSDE does not include security?
>>>>
>>>>Graig,
>>>>
>>>>MSDE's web site state: Enable security integrated with Windows NT
>>>>
>>>>http://msdn.microsoft.com/vstudio/msde/default.asp
>>>
>>>Does that mean it uses NT security or does it have SQL Server security?