Great Plains NT logins don't work

I'm working on a Great Pains installation and want to know if anyone with SQL or GP experience can help.

The server app and sql server are installed and GP insists that SQL server enable NT and SQL logins. No problem.  

Then set up the DSN so that it uses:

"With SQL server authentiation using a login ID and password entered by the user"
 and
"Connect to SQL server to obtain default settings for the additional configuration options" with the sa user account and password entered.  This is an absolute must according to the GP documentation.

Here's the obvious question.  My SQL logins work but the NT logins don't and what's the point of setting it up so that the server can accept both but the DSN is configured to only allow SQL logins.

When I try to use the NT login I get an error saying that there is no login information for that user on the SQL server.  I've given the test NT login all SQL security membership settings(groups, roles, permissions) as the working sql logins.

Any ideas on how I can make this work?  Thanks in advance!
LVL 1
zenportafinoAsked:
Who is Participating?
 
ee_ai_constructConnect With a Mentor Commented:
Question answered by asker or dialog valuable.
Closed, 400 points refunded.
ee_ai_construct (replacement part #xm34)
Community Support Admin
0
 
JaffaKREECommented:
wait, is the Domain/user added in the SQL Server instance, under logins, and also given the correct database permissions ?  Give it DBO to test.
0
 
zenportafinoAuthor Commented:
Sorry my bad.  It turns out that great plains can only let the sa account access GP at first.  After that, users have to be created in GP.  The SQL account needed is for the sa and the NT accounts are enabled just so that users can reach the login area.  Then they log into GP with thier assigned GP username and pwd.  I wish MS would explain this for admins who have never seen it in action before.  No wonder GP is a great consulting biz right now.
0
 
wiskCommented:
Let me know if you have future GP questions. I can help.

<email removed by CetusMOD per http:help.jsp#hi99>
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.