DynDeveloper.com

DynDeveloper.com

Sign Up Now! Log In
Hosea 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