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?
Asked
Active
Viewed 623 times
1
-
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 01: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 02:15
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
Ernest Marx
- 11
- 1
0
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.
Sankar Reddy
- 1,374
- 8
- 8
0
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.
slm
- 7,615
- 16
- 56
- 76
