Help. Getting a An error has occurred while establishing a connectionto the server. When connecting to SQL Server 2005, this failure may be causedby the fact that under the default settings SQL Server does not allow remote

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • aboutjav.com@gmail.com

    Help. Getting a An error has occurred while establishing a connectionto the server. When connecting to SQL Server 2005, this failure may be causedby the fact that under the default settings SQL Server does not allow remote

    Hi,

    I need some help. I am getting this error after I complete the asp.net
    register control and click on the continue button. It crashed when it
    tries to get
    it calls this Profile property

    ((string)(this. GetPropertyValu e("Address1"))) ;


    When I look at the stack, it is coming from my ProfileWrapper class
    which adds user address, city, etc.. from a class which inherits from
    System.Web.Prof ile.ProfileBase . From the stack, it is calling the
    System.Web.Prof ile and crashed when it tries to open a connection at
    System.Data.Pro viderBase.DbCon nectionPool.Get Connection(DbCo nnection
    owningObject). I already migrated all aspnet_user, aspnet_roles, etc..
    and don't get any connection errors. It is only when I try to get the
    profile data. This works on my pc, but throws an error on my
    lunarpage website.

    Any help is greatly appreciated.

    Thanks,

    AJ


    An error has occurred while establishing a connection to the server.
    When connecting to SQL Server 2005, this failure may be caused by the
    fact that under the default settings SQL Server does not allow remote
    connections. (provider: SQL Network Interfaces, error: 26 - Error
    Locating Server/Instance Specified)

    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.Data.Sql Client.SqlExcep tion: An error has
    occurred while establishing a connection to the server. When
    connecting to SQL Server 2005, this failure may be caused by the fact
    that under the default settings SQL Server does not allow remote
    connections. (provider: SQL Network Interfaces, error: 26 - Error
    Locating Server/Instance Specified)

    Source Error:

    Line 100: public virtual string Address2 {
    Line 101: get {
    Line 102: return ((string)
    (this.GetProper tyValue("Addres s2")));
    Line 103: }
    Line 104: set {


    Source File: c:\windows\Micr osoft.NET\Frame work\v2.0.50727 \Temporary
    ASP.NET Files\root\0021 d506\39a6858c\A pp_Code.54nvluy o.1.cs Line:
    102

    Stack Trace:

    [SqlException (0x80131904): An error has occurred while establishing a
    connection to the server. When connecting to SQL Server 2005, this
    failure may be caused by the fact that under the default settings SQL
    Server does not allow remote connections. (provider: SQL Network
    Interfaces, error: 26 - Error Locating Server/Instance Specified)]

    System.Data.Pro viderBase.DbCon nectionPool.Get Connection(DbCo nnection
    owningObject) +435

    System.Data.Pro viderBase.DbCon nectionFactory. GetConnection(D bConnection
    owningConnectio n) +82

    System.Data.Pro viderBase.DbCon nectionClosed.O penConnection(D bConnection
    outerConnection , DbConnectionFac tory connectionFacto ry) +105
    System.Data.Sql Client.SqlConne ction.Open() +111
    System.Web.Data Access.SqlConne ctionHolder.Ope n(HttpContext context,
    Boolean revertImpersona te) +84
    System.Web.Data Access.SqlConne ctionHelper.Get Connection(Stri ng
    connectionStrin g, Boolean revertImpersona tion) +197

    System.Web.Prof ile.SqlProfileP rovider.GetProp ertyValuesFromD atabase(String
    userName, SettingsPropert yValueCollectio n svc) +782

    System.Web.Prof ile.SqlProfileP rovider.GetProp ertyValues(Sett ingsContext
    sc, SettingsPropert yCollection properties) +428

    System.Configur ation.SettingsB ase.GetProperti esFromProvider( SettingsProvide r
    provider) +404
    System.Configur ation.SettingsB ase.GetProperty ValueByName(Str ing
    propertyName) +117
    System.Configur ation.SettingsB ase.get_Item(St ring propertyName) +89
    System.Web.Prof ile.ProfileBase .GetInternal(St ring propertyName) +36
    System.Web.Prof ile.ProfileBase .get_Item(Strin g propertyName) +68
    System.Web.Prof ile.ProfileBase .GetPropertyVal ue(String
    propertyName) +4
    ProfileCommon.g et_Address2() in c:\windows\Micr osoft.NET\Frame work
    \v2.0.50727\Tem porary ASP.NET Files\root\0021 d506\39a6858c\A pp_Code.
    54nvluyo.1.cs:1 02
    ProfileWrapper. .ctor() in d:\inetpub\vhos ts\javcentral.c om\httpdocs
    \App_Code\Profi leWrapper.cs:24 2
    ProfileDataSour ce.GetData() in d:\inetpub\vhos ts\javcentral.c om
    \httpdocs\App_C ode\ProfileData Source.cs:17

    [TargetInvocatio nException: Exception has been thrown by the target of
    an invocation.]
    System.RuntimeM ethodHandle._In vokeMethodFast( Object target,
    Object[] arguments, SignatureStruct & sig, MethodAttribute s
    methodAttribute s, RuntimeTypeHand le typeOwner) +0
    System.RuntimeM ethodHandle.Inv okeMethodFast(O bject target, Object[]
    arguments, Signature sig, MethodAttribute s methodAttribute s,
    RuntimeTypeHand le typeOwner) +72
    System.Reflecti on.RuntimeMetho dInfo.Invoke(Ob ject obj, BindingFlags
    invokeAttr, Binder binder, Object[] parameters, CultureInfo culture,
    Boolean skipVisibilityC hecks) +308
    System.Reflecti on.RuntimeMetho dInfo.Invoke(Ob ject obj, BindingFlags
    invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
    +29

    System.Web.UI.W ebControls.Obje ctDataSourceVie w.InvokeMethod( ObjectDataSourc eMethod
    method, Boolean disposeInstance , Object& instance) +480

    System.Web.UI.W ebControls.Obje ctDataSourceVie w.ExecuteSelect (DataSourceSele ctArguments
    arguments) +1960
    System.Web.UI.D ataSourceView.S elect(DataSourc eSelectArgument s
    arguments, DataSourceViewS electCallback callback) +17
    System.Web.UI.W ebControls.Data BoundControl.Pe rformSelect() +149
    System.Web.UI.W ebControls.Base DataBoundContro l.DataBind() +70
    System.Web.UI.W ebControls.Form View.DataBind() +4
    System.Web.UI.W ebControls.Base DataBoundContro l.EnsureDataBou nd()
    +82
    System.Web.UI.W ebControls.Form View.EnsureData Bound() +163

    System.Web.UI.W ebControls.Comp ositeDataBoundC ontrol.CreateCh ildControls()
    +69
    System.Web.UI.C ontrol.EnsureCh ildControls() +87
    System.Web.UI.C ontrol.FindCont rol(String id, Int32 pathOffset) +21
    System.Web.UI.C ontrol.FindCont rol(String id) +9
    CustomerDetails Edit.OnPreRende r(EventArgs e) in d:\inetpub\vhos ts
    \javcentral.com \httpdocs\UserC ontrols\Custome rDetailsEdit.as cx.cs:60
    System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +86
    System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +170
    System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +170
    System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +170
    System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +170
    System.Web.UI.P age.ProcessRequ estMain(Boolean
    includeStagesBe foreAsyncPoint, Boolean includeStagesAf terAsyncPoint)
    +2041

Working...