• Login
  • Register

DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.

Connection error after SQL server upgrade

You are not authorized to post a reply.
Sort:


New Member


Posts:1
New Member

    Hello,

    I recently upgraded my sql server version from 2016 to 2017. Now I get 'DNN Error Connection To The Database Failed' on all of my local DNN sites. My server name is the same. I have resynced logins but it does not seem to help. 

     Has anyone expericened this issuse and wouldn't mind sharing a resoultion?

    Please help! Thank you!



    Veteran Member


    Posts:466
    Veteran Member

      are you using same instance name for your new SQL server - otherwise you'll need to adopt the connection string in the web.config file of your DNN instance. Also make sure, if not using integratedsecurity in your connection string, that you need to setup your SQL Server for mixed authentication,


      Veteran Member


      Posts:1164
      Veteran Member

        You may need to enable mixed-mode authentication on the new SQL Server.
        Joe Craig
        DNN MVP
        Patapsco Research Group


        Veteran Member


        Posts:357
        Veteran Member

          @raymondvazquez Did you manage to resolve this issue?
          Will Strohl

          Upendo Ventures DNN experts since 2003
          Official provider of the DNN-based E-Commerce w/ Hotcakes Commerce Cloud and SLA support
          You are not authorized to post a reply.

          These Forums are dedicated to discussion of DNN Platform.

          For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

          1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
          2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
          3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
          4. No Flaming or Trolling.
          5. No Profanity, Racism, or Prejudice.
          6. Site Moderators have the final word on approving / removing a thread or post or comment.
          7. English language posting only, please.

          Would you like to help us?

          Awesome! Simply post in the forums using the link below and we'll get you started.

          Get Involved