Points: 7250

6/13/2017 1:10:28 PM

Setting Security in SQL for eConnect users

* This article, and all our great eConnect documentation, Is available on the eConnect menu

Today a client reported this error

Error processing document: \\<sql box>\<folders>\test\CM1700039_20170609150741.XML db: <dbname> Cannot open database "<dbname>" requested by the login. The login failed. Login failed for user '<domain name>\<user name>'. Complete Document: 7CM17/0003909766

eConnect uses SSPI security, meaning that it uses the credentials of the logged on user

Restated: The user that is logged on has to have security assigned to them in SQL

Screen shots below will walk you through it. 

Version: All
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