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?

link|improve this question

39% accept rate
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
feedback

2 Answers

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.

http://community.sageaccpac.com/blogs/r_and_d/archive/2011/03/05/diagnosing-problems-with-sage-erp-accpac-6-0a.aspx

link|improve this answer
feedback

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

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