Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Marcus 3 posts 73 karma points
    Oct 25, 2015 @ 15:28
    Marcus
    0

    SQL Express question

    wondering if SQL server is required?

    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

  • Damian Green 452 posts 1433 karma points
    Oct 25, 2015 @ 21:36
    Damian Green
    0

    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! :)

  • Marcus 3 posts 73 karma points
    Oct 26, 2015 @ 14:56
    Marcus
    0

    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

  • Wouter van der Beek 20 posts 282 karma points
    Oct 27, 2015 @ 13:00
    Wouter van der Beek
    1

    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!

  • Marcus 3 posts 73 karma points
    Oct 31, 2015 @ 15:39
    Marcus
    0

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

Please Sign in or register to post replies

Write your reply to:

Draft