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
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