July 29, 2008 at 7:24 am
If someone could please clarify for me: if SQL Server 2005 Express is installed to use Windows Authentication, can any future instances use SQL authentication OR must the server have been installed with (or be changed to) Mixed Mode?
Also, if a server is installed to use Mixed Mode can it have instances that use either SQL or Windows authentication?
Thanks so much for your input - I'm a little muddy on this concept in SQL 2005.
:unsure:
Imashe
July 29, 2008 at 1:43 pm
Ok - found my own answer! Apparently, in the Express Edition Windows authentication is not available.
Thanks anyway...
July 29, 2008 at 1:49 pm
The authentication method is Instance based not Server based so if I have 2 instances 1 can be Windows only and 1 can be mixed.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 29, 2008 at 1:54 pm
Jack - Thank you for the clarification - I very much appreciate it!
Imashe
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply