November 20, 2006 at 12:18 pm
Subscriptions using the printer extension act like they've been successful, but the printer never receives the print jobs.
Am running SS 2k5 Ent in a Win 2003 Ent environment.
I've installed the extension following the steps here. The extension shows up in the subscriptions screen as it should, and I've put the appropriate printer in the RSReportServer.config file. If I put the printer name in incorrectly, the subscription screen errors as it should. So, I know the printer has been put in correctly because it doesn't error.
The (network) printer has been added locally, and permissions have been set so Everyone can print to it.
When the subscription is set to run, SQL Agent reports that it has run successfully, all steps. However, the printer never receives a print job. The only seemingly related events I've found in Event Viewer is an application error: "Report Manager cannot load the Printer Delivery Sample extension." Odd thing is, it's happened five times over the space of several weeks, and none of those times correlate to when a subscription ran, nor when any services started or stopped. I've looked on google, live.com, and msdn, and none have any results for this error.
I'm at a loss. Any ideas?
November 21, 2006 at 9:23 am
>>I've looked on google, live.com, and msdn, and none have any results for this error.
I found this:
http://weblogs.asp.net/taganov/archive/2004/03/04/83858.aspx
... lots of problems with SQL versus Windows auth being used for credentials at various steps in the process (it seemed to me from a quick scan of this thread), I don't know if this would be relevant to your situation.
However, you will find that one question (guy from Uruguay) does mention the same issue that you have. He was pointed to this article: http://www.csharphelp.com/archives3/archive545.html
... which, AFAICS is a low-level approach to the same thing the sample does. IOW, use the .Net framework directly to print rather than trying to use the sample at all. It's not really that hard to do. The client app is requesting the report in EMF format and then sending the EMF to the printer.
There are probably several ways you could improve on the csharphelp article a bit to show a printer dialog, etc. I am not sure whether this would meet your needs because it's not clear to me what kind of client you are actually using or how it invokes RS.
I'm sorry that I can't give you more specific information on the printer extension sample, having never used it. However, the steps involved in the page you cite (and included in the extension readme file) are sufficiently involved that I would double check each one <g>. (Did you, for example, reset IIS at the end?) Also, are you using a named instance or the default instance? Just about anything might throw off some configuration piece of the sample, IMHO.
>L<
December 18, 2006 at 11:05 am
Lisa,
Thanks for the reply, sorry for the delayed response.
The more I get to know .Net, the more I wonder if you're right about going low-level. In the end, what I'd like is to simply have another method of delivery (via printer) that any subscription can use to print to any printer on our lan. I hope it's as easy as you think it is.
December 18, 2006 at 11:52 am
>>In the end, what I'd like is to simply have another method of delivery (via printer) that any subscription can use to print to any printer on our lan.
I understand -- but forgive me it's been a while since we started this discussion -- do you want that channel integrated into the way your client subscribers currently get other forms of output? If so, what are your current client mechanisms? If not, would you create a little client EXE for this purpose, or what did you envision?
>> I hope it's as easy as you think it is.
I don't know what your programming background is, and mine is pretty weird <g>, so what might seem easy or hard to one person is sort of irrelevant to what another person thinks. Give a holler (e-mail) if you decide to do this and get stuck on a .NET point regarding the printing mechanism/subsystem. I've used the more low-level approach in several other scenarios -- just don't have any experience doing it with RS and have never dealt with the samples.
Regards,
>L<
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply