printing fails | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

printing fails

Hi folks, We have a DTS job that data pulled from MSSQL to a printer. When I run the job myself, it prints out. But when I schedule the job, it fails. The error message isn’t much helpful. The error message is: SQL Server Scheduled Job ‘Centralized Printing ClientXXX’ (0x37900D4C21CB8C41812D25CAD98964E6) – Status: Failed – Invoked on: 2007-05-25 14:05:00 – Message: The job failed. The Job was invoked by Schedule 30 (Centralized Printing ClientXXX). The last step to run was step 1 (Centralized Printing ClientXXX). Can someone please help me on how to troubleshoot this issue? It could be permission issue. Where will I assign the account that is running the sqlagent? Thanks, V
Is printer setup on the server?
If you run the dts package it runs from your desktop/laptop where as when it runs as a job it run from the server….
so make sure printer is configured properly and SQL Agent services has the enough right…
In computer management/Services check for sql server agent service and the account which can have the permissions…
Moderator All postings are provided “AS IS” with no warranties for accuracy.

The printer was created under my username. The service account is a member of administrator. I’m thinking that the service account is not seeing the printer I created. What is the work around for this?

Configure the printer when you logged on to the server using sql service accout…
Moderator All postings are provided “AS IS” with no warranties for accuracy.

If you don’t have the facility to login using Service account then you need to grant FULLCONTROL permission for that service account. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.