Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
Peter 11/14/2007 4:41:21 PM

Integrated Security and eConnect - any way around it?

The eConnect 9.0 libraries require the usage of Integrated Security with SQL Server. This means that every end user of my application (which uses eConnect to talk to GP) would need login rights to the GP SQL Server, no? That doesn't make any sense.

Is there a way that I can force them all to log into SQL Server with the same credentials. Would I have to do some tricks with impersonation in my application code? Has anyone attempted something like this before?

Thanks in advance.




Version: Unknown or N/A
Section: eConnect

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables