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"
"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!