• Login
  • Register

DNN Forums

A community discussion page. We're starting from scratch, so...let's get the party started!

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!



    Basic Member


    Posts:107
    Basic 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,


      Advanced Member


      Posts:189
      Advanced Member

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


        Veteran Member


        Posts:291
        Veteran Member

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

          Upendo Ventures Upendo Ventures
          DNN experts since 2003
          Official provider of the 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