SQL Express setup on azure seems to cause this error when sending test email
An error occured while sending the testmail. Please try again: A
network-related or instance-specific error occurred while establishing
a connection to SQL Server. The server was not found or was not
accessible. Verify that the instance name is correct and that SQL
Server is configured to allow remote connections. (provider: SQL
Network Interfaces, error: 26 - Error Locating Server/Instance
Specified)
any thoughts or details on requirements? - I've looked across all the docs and your site, and there are no requirements mentioned regarding SQL
I think that the package requires sql server as it may be using transact sql statements.
I cannot find this as a requirement in the package requirements.
thanks
Currently the package requires an SQL database in order to work. With that being said, this is mostly for logging purposes and is not related to the actual creation and sending of the email. However without it the statistics module (in Umbraco) and the e-mail tracking will not work.
Making the SQL database optional in a future version is something we might consider (and this probably would not be very complicated to achieve), however we will most likely not be making this change in the near future as currently our main focus is expanding the package with new features and providing (bug)fixes where required.
The sourcecode for the PerplexMail package is available on Github, so if you require a short term solution you may be able to make the required modifications yourself to make the package work with your solution:
I also would like to make a sidenote that the PerplexMail package has NOT been tested in an Azure hosting environment. For our next update we would like to make sure that the package is 100% compatible with Azure-hosted Umbraco installations, so if you have any contributions or ideas, please let us know!
Thanks Wouter.
truthfully I pretty much suspected this.
perhaps there should be system requirements that include SQL Server - since Out of the box Umbraco, specifically on Azure, uses SQL Express.
thanks :)
SQL Express question
wondering if SQL server is required?
SQL Express setup on azure seems to cause this error when sending test email
any thoughts or details on requirements? - I've looked across all the docs and your site, and there are no requirements mentioned regarding SQL
What code are you using to send email? An umbraco helper/library?
Just use the basic .net classes instead to send email and put the email config in web.config.
** edit to note i didn't notice it was a package - assumed it was just umbraco! :)
using perplexmail
I think that the package requires sql server as it may be using transact sql statements. I cannot find this as a requirement in the package requirements. thanks
Hello Marcus,
Currently the package requires an SQL database in order to work. With that being said, this is mostly for logging purposes and is not related to the actual creation and sending of the email. However without it the statistics module (in Umbraco) and the e-mail tracking will not work.
Making the SQL database optional in a future version is something we might consider (and this probably would not be very complicated to achieve), however we will most likely not be making this change in the near future as currently our main focus is expanding the package with new features and providing (bug)fixes where required.
The sourcecode for the PerplexMail package is available on Github, so if you require a short term solution you may be able to make the required modifications yourself to make the package work with your solution:
https://github.com/PerplexInternetmarketing/PerplexMail-for-Umbraco
I also would like to make a sidenote that the PerplexMail package has NOT been tested in an Azure hosting environment. For our next update we would like to make sure that the package is 100% compatible with Azure-hosted Umbraco installations, so if you have any contributions or ideas, please let us know!
Thanks Wouter. truthfully I pretty much suspected this. perhaps there should be system requirements that include SQL Server - since Out of the box Umbraco, specifically on Azure, uses SQL Express. thanks :)
is working on a reply...