SQL Agent and N_Connect

Post Reply
telula_w
Posts: 15
Joined: Wed Jan 05, 2011 11:28 pm
OLAP Product: TM1
Version: 9.1
Excel Version: 2003

SQL Agent and N_Connect

Post by telula_w »

Hello,
I have created a cmd and vbs script that opens up excel, runs the N_Connect macro. This cmd is attached to SQL agent.This has been working fine for 2 weeks until IT installs Cisco Communicator v8. Now my spreadsheet is saved with #VALUES indicating it is an access issue. The sql agent has a service account which has permission in TM1. Note that it was working before the Communicator installation.Is there someone out there who has this problem before?
Post Reply