Unable to connect SqlServer

Discussion in 'ASP.NET / ASP.NET Core' started by mod2tecno, Sep 27, 2011.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. mod2tecno

    mod2tecno

    Hi all, on my site (www.mod2tecno.com/mod2tecno) i have a silverlight app .
    This app try to connect to sqlserver for membership and data.

    I've this 2 connection strings


    Code:
    <connectionStrings>
    <add name="ApplicationServices" connectionString="data source=tcp:esql2k803.discountasp.net;Integrated Security=False;Initial Catalog=SQL2008R2_841133_mod2;User ID=SQL2008R2_841133_mod2_user;Password=*****;" providerName="System.Data.SqlClient" />
    <add name="DbMod2Entities" connectionString="metadata=res://*/Models.DbMod2Model.csdl|res://*/Models.DbMod2Model.ssdl|res://*/Models.DbMod2Model.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source==tcp:esql2k803.discountasp.net;Initial Catalog=SQL2008R2_841133_mod2;Integrated Security=False;MultipleActiveResultSets=True;User id=SQL2008R2_841133_mod2_user;Password=*****&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>
    Obviously the password is not "*****" ;)

    I always receive "Server not Found" from my app when it try to connect at db.

    Can you help me ?
    Thanks
     
    mod2tecno, Sep 27, 2011
    #1
  2. Joseph Jun

    Joseph Jun DiscountASP.NET Staff

    The Silverlight-related error that you're seeing is a bit misleading and for some more information on troubleshooting, I would highly recommend checking out the "How to troubleshoot Silverlight RIA Applications" article in the DiscountASP.NET Blog.

    I accessed your site while running Fiddler and here's the error details:

    IIS specified authentication schemes 'Basic, Anonymous', but the binding only supports specification of exactly one authentication scheme. Valid authentication schemes are Digest, Negotiate, NTLM, Basic, or Anonymous. Change the IIS settings so that only a single authentication scheme is used.
    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.InvalidOperationException: IIS specified authentication schemes 'Basic, Anonymous', but the binding only supports specification of exactly one authentication scheme. Valid authentication schemes are Digest, Negotiate, NTLM, Basic, or Anonymous. Change the IIS settings so that only a single authentication scheme is used.​


    Check the following DiscountASP.NET Knowledge Base article for a resolution:

    http://support.discountasp.net/KB/a803/error-accessing-wcf-service-iis-specified-authentication.aspx
     
    Joseph Jun, Sep 27, 2011
    #2
  3. mod2tecno

    mod2tecno

    Hi Joseph , many thank for your help!
    Now is OK!
     
    mod2tecno, Sep 28, 2011
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page