Why it is giving me 401 Unauthorized Error when i am running it fr

[Parth]

Hi,

i want to publish the project with the PSI and i am doing that,
now i want to put that EXE file in C drive and want to Run that from the SQL
Server that is also i am doing it,

but what is not happening is When i am running EXE from SQL; it is giving me
the 401 Error and when i am running that EXE manually i am able to publish
that data;

though i have put that EXE in Windows Scheduler and Able to publish the
project after certain interval but my Quesion is:

Why it is giving me 401 Unauthorized Error when i am running it from SQL
Server??

Please clear my doubt ASAP.

Help !

Thanks

Parth

 

[Stephen Sanderlin]

Am I reading this correctly?
1) When you run the EXE from the SQL server manually it fails with a
401 error,
2) When you run the EXE from another system manually it succeeds, and
3) When you create a scheduled task on the SQL Server to run the EXE,
it succeeds.

Is that correct?

--
Stephen Sanderlin
Principal Consultant
MSProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read my blog at: http://www.projectserverhelp.com
Join the community at: http://forums.epmfaq.com

 

[Parth]

Yes Except for the 3rd one i have created Schedule tasks in Windows scheduler,
and from there it is running ok,

but what if i want to put in JOB of SQL server then???


Why it is happening like this???


Please made my doubts clear Please.

Thanks

Parth

 

[Stephen Sanderlin]

The only thing that comes to mind is that the user account you are using
to interactively log on to the SQL server doesn't have access.

I'm not sure what you mean by but what if i want to put in JOB of SQL
server then"? Are you asking how you can run your EXE from a scheduled
job within SQL Server?

--
Stephen Sanderlin
Principal Consultant
MSProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read my blog at: http://www.projectserverhelp.com
Join the community at: http://forums.epmfaq.com

 

[Parth]

I know that, how to run that but while running it,
it is giving the Error (while running from SQL)

the same code i am able to run using Task Scheduler of Windows then it is
running perfectly fine....WHY ????

and Let me know my scenarion why i am doing this??

when a user updates a task and that task has been approved by the Manager it
should reflect the changes in the Project Details but untill we publish that
project we are not able to reflect that data inside that project Center's
Project.

and this leads us to Publish the project using Scheduler.

Thanks

Parth

 

[Stephen Sanderlin]

To be perfectly honest, I'm not sure why it's giving you the error from
SQL. If you are using the same user account in the same domain in all
three scenarios then it should work. If you post your code, I'll be
happy to take a look at it for you, but I think that you may need
someone to take a "hands-on" look at your problem.

As far as your reasoning for writing a scheduler, the best practice is
to train status managers to publish the project after they approve time.
This is really a training issue that can be resolved with training
rather than technology.

In general, the use of auto-publishers is not recommended because it
takes so much control away from project manager. They also make it
rather trivial to publish data which the project manager may not have
wanted published.

Regards,
Stephen

--
Stephen Sanderlin
Principal Consultant
MSProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read my blog at: http://www.projectserverhelp.com
Join the community at: http://forums.epmfaq.com