sa password changed, where can we add a new user / password
When I go to one of our maps and click on Companies Button, I get error that the logged user does not have security access.
we also get this message when running the map.
I have tired everything I can think of.
I think you have to go under SC Setup > Setup > SmartConnect Setup > MS GP Connector SEtup
in that form you have under settings the SQL user that is used to identify against the GP server and allows for selecting the proper DB’s. If you don’t want to use the ‘sa’ user, chose one that has enough rights to access correctly all the DB’s and also be able to alter SQL objects if triggers needs to be setup.
Thanks that did it
If you would like to submit an answer or comment, please sign in to the eOne portal.