Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm the DBA and the Accpac guy is telling me we need a SQL login for the Accpac databases. Right now I use only Windows authentication, and I don't like the idea of turning on mixed authentication if I don't have to. So before I agree to it, I want to make sure it's necessary. Can Accpac use Windows logins?

share|improve this question
even if someone pops up and tells you how to work around it, are you going to go against the supported config? – Jim B May 25 '11 at 1:57
My question is what is the supported config? Where do I find the info? Google doesn't answer my question, maybe because I don't know what to ask? I don't know anything about Accpac. – ScottStonehouse May 25 '11 at 2:15

You can use accpac 6 and windows authentication. you do not have to use both. your accpac server should be part of the domain in order for it to run more effectively

share|improve this answer

I am NOT sure how many folks are well versed with AccPac here and I have never heard of them until today. Your best bet is ask the AccPac guy to provide documentation (potentially from the company's manual) why only SQL authentication is preferred and the windows authentication.

From the website, it looks like they allow windows authentication too but not clear enough.

share|improve this answer

You should use SQL login details for accpac for it to really work else you won't be able to access accpac database when there is trouble. More so, portal setup in accpac only accepts SQL login details so ensure you use mix mode authentication for your SQL.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.