Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2016
    Posts
    1

    Unanswered: SQl provider Error

    i am trying to connect online sql db to mvc application but getting "Underlying provider failed" error
    <!--<add name="Shopping" connectionString="metadata=res://*/Models.DAL.ShoppingModel.csdl|res://*/Models.DAL.ShoppingModel.ssdl|res://*/Models.DAL.ShoppingModel.msl;provider=System.Data. SqlClient;provider connection string=&quot;data source=198.71.226.2;initial catalog=Shopping;persist security=True;user id=healthkart123;password=rugnalay*healthkart;Mult ipleActiveResultSets=True;App=EntityFramework&quot ;" providerName="System.Data.EntityClient" />-->

    this is my connection string.

    connection is successful for local db but problem with online db

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,794
    Provided Answers: 11
    Have you checked to see if
    1) The local firewall on the database machine is allowing traffic to the port SQL Server is listening on
    2) SQL Server is listening on TCP/IP

  3. #3
    Join Date
    Jun 2011
    Posts
    31
    Provided Answers: 1
    Check the steps of this article: http://www.technologycrowds.com/2015...d-on-open.html

    Good Luck!

  4. #4
    Join Date
    Jan 2016
    Posts
    23
    Provided Answers: 1
    Try this

    1. Search "Component Services" in the Programs and Files
    2. Go to the Services
    3. Find "Distributed Transaction Coordinator" Service
    4. Right click and Restart the Service

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •