Home / server / Questions / 273432
In Process
ScottStonehouse
Asked: 2011-05-25 15:53:45 +0800 CST

Can Accpac be used with Windows authentication for SQL Server?

  • 772

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?

sql-server sql-server-2008 windows-authentication accounting

3 Answers

  1. 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

    • 1

  2. 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

    • 0

  3. 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.

    • 0