We are trying to print a batch of documents with the help of the reporting service. The logfile shows :
2019-03-01 08:39:47.5227|ERROR|dev_cf_finas|115|Printer name '\\digiserver\Thinkwise_Facturen' not found in installed printers. Valid values are: Microsoft XPS Document Writer.
2019-03-01 08:39:47.5383|FATAL|dev_cf_finas|115|Something went wrong while processing this report: Printer name '\\digiserver\Thinkwise_Facturen' not found in installed printers. Valid values are: Microsoft XPS Document Writer.
We are using shared printers on a specific server. It looks like it can not find these shared printers, only locally installed printers. Is there a way to get access to the shared printers?
Solved
Reporting Service and shared printers
Best answer by Anne Buit
Hi Hugo,
Executing this command in SQL Server Management Studio will list the available printers for the service account running the SQL Server Agent. This service account is probably never used to load the report.
The Windows GUI runs the report locally under the clients' Windows account. Try executing the powershell command on one of those local machines to see if the printer shows up here. Since the reports work, I suspect they do.
The Reporting Service runs the report under a specific service account. You can find this account by running services.msc on the machine running the Reporting Service.
Try to run the powershell command on the machine hosting the Reporting Service using this service account and check if the printers are installed for this service account. I suspect they are not available. Likewise, the UNC path is probably not available to this service account either.
View originalExecuting this command in SQL Server Management Studio will list the available printers for the service account running the SQL Server Agent. This service account is probably never used to load the report.
The Windows GUI runs the report locally under the clients' Windows account. Try executing the powershell command on one of those local machines to see if the printer shows up here. Since the reports work, I suspect they do.
The Reporting Service runs the report under a specific service account. You can find this account by running services.msc on the machine running the Reporting Service.
Try to run the powershell command on the machine hosting the Reporting Service using this service account and check if the printers are installed for this service account. I suspect they are not available. Likewise, the UNC path is probably not available to this service account either.
This topic has been closed for comments
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.