Report Server Problem accessing network share sending email

Hi Naga,

Thanks for the info. I’ve just tried enabling “named pipes” as it needed a restart of SQL but unfortunately it’s had no effect.

Correct me if I’m wrong but the database mail part of SQL connects to network shares as the account that the SQL service is running as?

The error I’m getting is suggesting this account does not have permission to collect the pdf from the folder. At the moment the folder is local to the SQL server so permissions should be simple.

Thanks

Mike Cornthwaite
ICT Manager
Theatre by the Lake

Telephone: 017687 72282
Email: mike.cornthwaite@theatrebythelake.com
Box Office 017687 74411
Web: www.theatrebythelake.com

Theatre by the Lake is the operating name of Cumbria Theatre Trust. A Company Limited by Guarantee. Registered in England No. 1874868.
Registered Charity Number 516673.

This document is strictly confidential and is intended only for use by the addressee. If you are not the intended recipient, any disclosure, copying, distribution or other action taken in reliance of the information contained in this e-mail is strictly prohibited.

Any views expressed by the sender of this message are not necessarily those of Cumbria Theatre Trust. If you have received this transmission in error, please use the reply function to tell us and then permanently delete what you have received.

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Naga Kakarla
Sent: 02 September 2014 16:17
To: Mike Cornthwaite
Subject: Re: [Tessitura Technical Forum] Report Server Problem accessing network share sending email

Hi Mike,

We had some similar issues with the report server emails not coming through after we migrated to a new SQL server. Our issue was resolved after enabling the "Named Pipes" in the SQL Server Configuration. Not sure if this applies to your setup?

Regards,

Naga 

Hi there,

We are having quite a bit of trouble with the report server failing to send emails out using sql database mail.

The report sever creates the pdf files fine and as far as I can tell the permissions on the folder is ok however we get the following error each time which seems to be coming from the database mail component.

Error sending email:

SQLSTATE = 42000

Microsoft OLE DB Provider for SQL Server

C:\impftp\report\SystemTableListing_14032.pdf is not a valid file or the process is unable to access the file.

The report server application runs as the same user account as the SQL server service account with both on the same box. I have tried using a network share and a local path for the reports folder but both have the same issue.

The tessituraservices application pool runs on a different server under the applicationpoolidentity and I have tried allowing the machine account of this server to access the reports folder but the same issue occurs.

Strangely it broke after we moved the live DB to another SQL server but I got it working however it stopped on the weekend and I have no idea why it won't work.

Any help would be much appreciated

Thanks

Mike Cornthwaite

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Hi Naga,

Thanks for the info. I’ve just tried enabling “named pipes” as it needed a restart of SQL but unfortunately it’s had no effect.

Correct me if I’m wrong but the database mail part of SQL connects to network shares as the account that the SQL service is running as?

The error I’m getting is suggesting this account does not have permission to collect the pdf from the folder. At the moment the folder is local to the SQL server so permissions should be simple.

Thanks

Mike Cornthwaite
ICT Manager
Theatre by the Lake

Telephone: 017687 72282
Email: mike.cornthwaite@theatrebythelake.com
Box Office 017687 74411
Web: www.theatrebythelake.com

Theatre by the Lake is the operating name of Cumbria Theatre Trust. A Company Limited by Guarantee. Registered in England No. 1874868.
Registered Charity Number 516673.

This document is strictly confidential and is intended only for use by the addressee. If you are not the intended recipient, any disclosure, copying, distribution or other action taken in reliance of the information contained in this e-mail is strictly prohibited.

Any views expressed by the sender of this message are not necessarily those of Cumbria Theatre Trust. If you have received this transmission in error, please use the reply function to tell us and then permanently delete what you have received.

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Naga Kakarla
Sent: 02 September 2014 16:17
To: Mike Cornthwaite
Subject: Re: [Tessitura Technical Forum] Report Server Problem accessing network share sending email

Hi Mike,

We had some similar issues with the report server emails not coming through after we migrated to a new SQL server. Our issue was resolved after enabling the "Named Pipes" in the SQL Server Configuration. Not sure if this applies to your setup?

Regards,

Naga 

Hi there,

We are having quite a bit of trouble with the report server failing to send emails out using sql database mail.

The report sever creates the pdf files fine and as far as I can tell the permissions on the folder is ok however we get the following error each time which seems to be coming from the database mail component.

Error sending email:

SQLSTATE = 42000

Microsoft OLE DB Provider for SQL Server

C:\impftp\report\SystemTableListing_14032.pdf is not a valid file or the process is unable to access the file.

The report server application runs as the same user account as the SQL server service account with both on the same box. I have tried using a network share and a local path for the reports folder but both have the same issue.

The tessituraservices application pool runs on a different server under the applicationpoolidentity and I have tried allowing the machine account of this server to access the reports folder but the same issue occurs.

Strangely it broke after we moved the live DB to another SQL server but I got it working however it stopped on the weekend and I have no idea why it won't work.

Any help would be much appreciated

Thanks

Mike Cornthwaite

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!