Service Account Authentication

[SIMMS7400]

Good Morning Folks!

I'm having an issue with my MS ACESS model as it's asking me for my Service Account credentials eveyrtime I kick off my batch script.

A little color:

I have an MS ACCESS Model that publishes a SharePoint list. If I execute the procedure from my local machine, I am not prompted for any creentials. However, we moved the model to a server (so I wouldn't be the bottle neck). When we kick off the batch script to inistate the SharePoint refresh, we are then prompted for our Service Account credentials.

For instance:

REM --------------------------------
REM SET MS ACCESS VARIABLES
REM --------------------------------

SET MSACCESSEXE="C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE"
SET MSACCESSMODEL1="C:\DRM_PROJECT\MODELS\HBU_PJ_Codes 1.accdb" /x AutoExec



:ExecuteMSAccess
echo ************************************************** ******>>%logfile%
echo Call MS ACCESS to execute AutoExec Macro at %TIME% >>%logfile%
echo ************************************************** ******>>%logfile%

CALL %MSACCESSEXE% %MSACCESSMODEL1%


Even with "Remember my credentials" checked off, it still prompts every time. The SharePoint list/site has been updated to reflect "ServiceHyperion" as a user, but it has not fixed the issue.



Can anyone recommend any solutions? At this point, this cannot be schedule nightly due to the issue. Why will it execute fine locally but not with our ServiceAccount on the server?

Thank you!

[Perceptus]

So that batch file on your local machine has no issues. but it bombs on credentials when you try to schedule it?

[SIMMS7400]

Batch file on my local machine runs fine - no credentials need to be provided. (scheduled or ad-hoc)

However, when I execute the script on the server, (ad-hoc or scheduled) it prompts me to enter the password of my Service Account. Once I do so, it then finishes successfully.

Attaching a picture of the prompt:

[SIMMS7400]

Batch file on my local machine runs fine - no credentials need to be provided. (scheduled or ad-hoc)

However, when I execute the script on the server, (ad-hoc or scheduled) it prompts me to enter the password of my Service Account. Once I do so, it then finishes successfully.

Attaching a picture of the prompt:

[IMG][/IMG]

[Perceptus]

Sounds like your credentials are cached locally but not so much on the server. I will ask my IT mentor.