Windows auth uses local/domain account for authentication to the db. It depends on how your sql server is configured. If the domain account has access to the sql server, and you want to authenticate to sql using windows authentication, then you want to use windows authentication. If you have a sql account for the db, then you need to use the other auth option.
Axton Grams On 11/17/06, Richard Copits <[EMAIL PROTECTED]> wrote:
** We've "inherited" a production system that's in and running. We're now trying to learn how to install a test server using 6.3. However, in the install we get to a step asking for SQL information "Microsoft SQL Server Settings" where it gives a choice box for windows authencation. I guess my questions are: What is this really doing? Is it creating a local user, and if so, whats the reason for it doing that? I have a domain account "ARAdmin" with a domain level password - do I use that here or ??? I guess I'm totally baffled by this screen, what it's asking for the info for, and what I should be typing in. Any suggestions/clarifications are sincerely welcomed!! Thanks!! Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. __20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
