SYMPTOM:
A service created with a subscription set defined with Pre/Post SQL fails to get executed. DELog has following error messages:
Service ID Execution ID Segment ID [] Calling SBM to divide service execution into segments.:1988:
Error Connecting to Database for Pre/Post SQL statement: Test Statement - Invalid authorization specification (User ID or Password is incorrect).:3400:
Test connection at the SQL statements window works fine, as shown below:
CAUSE:
Service accounts for Distribution Manager and Execution Engine are defined with Local System account and the DSN is set up to use NT Authentication. The Local System Account does not have any netwrok privileges, as shown below:
ACTION:
Change to 'This account' and specify the NT User as specified in the DSN, as shown below:
17289
