|
.net
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Custom membership provider problemI was working fine with create user wizard and the default membership provider. I have now customised the membership provider as per attached web.config. The create user wizard picks up the custom membership provider fine and removes the security question/answer fields as designated in the custom provider. The problem is that when I try to create a new user in the create user wizard by entering the info and pressing the 'create user' button, I get the below error. What am I doing wrong and how can I fix it? I created the aspnetdb db using the aspnet_regsql.exe tool. Thanks Regards Server Error in '/Events' Application. -------------------------------------------------------------------------------- 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: 25 - Connection string is not valid) 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.SqlClient.SqlException: 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: 25 - Connection string is not valid) Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. 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: 25 - Connection string is not valid)] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734979 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +820 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197 System.Web.Security.SqlMembershipProvider.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, Object providerUserKey, MembershipCreateStatus& status) +3612 System.Web.UI.WebControls.CreateUserWizard.AttemptCreateUser() +305 System.Web.UI.WebControls.CreateUserWizard.OnNextButtonClick(WizardNavigationEventArgs e) +105 System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) +453 System.Web.UI.WebControls.CreateUserWizard.OnBubbleEvent(Object source, EventArgs e) +149 System.Web.UI.WebControls.WizardChildTable.OnBubbleEvent(Object source, EventArgs args) +17 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42 [attached file: web.config] On Sat, 17 Dec 2005 03:04:17 -0000, "John" <John@nospam.infovis.co.uk> SQL server 2005 does not install with the TCP/IP protocol turned on.wrote: You must turn it on to cure this problem. Show quote >Hi > >I was working fine with create user wizard and the default membership >provider. I have now customised the membership provider as per attached >web.config. The create user wizard picks up the custom membership provider >fine and removes the security question/answer fields as designated in the >custom provider. > >The problem is that when I try to create a new user in the create user >wizard by entering the info and pressing the 'create user' button, I get the >below error. > >What am I doing wrong and how can I fix it? I created the aspnetdb db using >the aspnet_regsql.exe tool. > >Thanks > >Regards > > >Server Error in '/Events' Application. >-------------------------------------------------------------------------------- > >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: 25 - Connection string is not >valid) >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.SqlClient.SqlException: 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: 25 - Connection string is not valid) > >Source Error: > > > An unhandled exception was generated during the execution of the >current web request. Information regarding the origin and location of the >exception can be identified using the exception stack trace below. > > >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: 25 - >Connection string is not valid)] > System.Data.SqlClient.SqlInternalConnection.OnError(SqlException >exception, Boolean breakConnection) +734979 > System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject >stateObj) +188 > System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, >Boolean& failoverDemandDone, String host, String failoverPartner, String >protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean >encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection >owningObject, Boolean aliasLookup) +820 > System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection >owningObject, SqlConnectionString connectionOptions, String newPassword, >Boolean redirectedUserInstance) +628 > System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity >identity, SqlConnectionString connectionOptions, Object providerInfo, String >newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) >+170 > System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions >options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection >owningConnection) +130 > System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection >owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 > System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection >owningObject) +424 > System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection >owningObject) +66 > System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection >owningObject) +496 > System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection >owningConnection) +82 > System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection >outerConnection, DbConnectionFactory connectionFactory) +105 > System.Data.SqlClient.SqlConnection.Open() +111 > System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, >Boolean revertImpersonate) +84 > System.Web.DataAccess.SqlConnectionHelper.GetConnection(String >connectionString, Boolean revertImpersonation) +197 > System.Web.Security.SqlMembershipProvider.CreateUser(String username, >String password, String email, String passwordQuestion, String >passwordAnswer, Boolean isApproved, Object providerUserKey, >MembershipCreateStatus& status) +3612 > System.Web.UI.WebControls.CreateUserWizard.AttemptCreateUser() +305 > System.Web.UI.WebControls.CreateUserWizard.OnNextButtonClick(WizardNavigationEventArgs >e) +105 > System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs >e) +453 > System.Web.UI.WebControls.CreateUserWizard.OnBubbleEvent(Object source, >EventArgs e) +149 > System.Web.UI.WebControls.WizardChildTable.OnBubbleEvent(Object source, >EventArgs args) +17 > System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 > System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115 > System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) >+163 > System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String >eventArgument) +7 > System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler >sourceControl, String eventArgument) +11 > System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 > System.Web.UI.Page.ProcessRequestMain(Boolean >includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102 > > > > > >-------------------------------------------------------------------------------- > >Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET >Version:2.0.50727.42 > Sorry forgot to mention, did that already using the surface configuration
tool. Everything was working fine until I switched to the custom membership provider as I did not need the security question/answer fields in the create user wizard and someone said I should switch to custom membership provider. Thanks Regards <mablej***@otismukinfus.com> wrote in message Show quote news:9847q1d3condk6kp471pktoljk4i5381co@4ax.com... > On Sat, 17 Dec 2005 03:04:17 -0000, "John" <John@nospam.infovis.co.uk> > wrote: > > SQL server 2005 does not install with the TCP/IP protocol turned on. > You must turn it on to cure this problem. > >>Hi >> >>I was working fine with create user wizard and the default membership >>provider. I have now customised the membership provider as per attached >>web.config. The create user wizard picks up the custom membership provider >>fine and removes the security question/answer fields as designated in the >>custom provider. >> >>The problem is that when I try to create a new user in the create user >>wizard by entering the info and pressing the 'create user' button, I get >>the >>below error. >> >>What am I doing wrong and how can I fix it? I created the aspnetdb db >>using >>the aspnet_regsql.exe tool. >> >>Thanks >> >>Regards >> >> >>Server Error in '/Events' Application. >>-------------------------------------------------------------------------------- >> >>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: 25 - Connection string is not >>valid) >>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.SqlClient.SqlException: 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: 25 - Connection string is not valid) >> >>Source Error: >> >> >> An unhandled exception was generated during the execution of the >>current web request. Information regarding the origin and location of the >>exception can be identified using the exception stack trace below. >> >> >>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: >>25 - >>Connection string is not valid)] >> System.Data.SqlClient.SqlInternalConnection.OnError(SqlException >>exception, Boolean breakConnection) +734979 >> >> System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject >>stateObj) +188 >> System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, >>Boolean& failoverDemandDone, String host, String failoverPartner, String >>protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean >>encrypt, Boolean trustServerCert, Boolean integratedSecurity, >>SqlConnection >>owningObject, Boolean aliasLookup) +820 >> >> System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection >>owningObject, SqlConnectionString connectionOptions, String newPassword, >>Boolean redirectedUserInstance) +628 >> >> System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity >>identity, SqlConnectionString connectionOptions, Object providerInfo, >>String >>newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) >>+170 >> >> System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions >>options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection >>owningConnection) +130 >> >> System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection >>owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 >> System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection >>owningObject) +424 >> >> System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection >>owningObject) +66 >> System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection >>owningObject) +496 >> System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection >>owningConnection) +82 >> System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection >>outerConnection, DbConnectionFactory connectionFactory) +105 >> System.Data.SqlClient.SqlConnection.Open() +111 >> System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, >>Boolean revertImpersonate) +84 >> System.Web.DataAccess.SqlConnectionHelper.GetConnection(String >>connectionString, Boolean revertImpersonation) +197 >> System.Web.Security.SqlMembershipProvider.CreateUser(String username, >>String password, String email, String passwordQuestion, String >>passwordAnswer, Boolean isApproved, Object providerUserKey, >>MembershipCreateStatus& status) +3612 >> System.Web.UI.WebControls.CreateUserWizard.AttemptCreateUser() +305 >> >> System.Web.UI.WebControls.CreateUserWizard.OnNextButtonClick(WizardNavigationEventArgs >>e) +105 >> System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs >>e) +453 >> System.Web.UI.WebControls.CreateUserWizard.OnBubbleEvent(Object source, >>EventArgs e) +149 >> System.Web.UI.WebControls.WizardChildTable.OnBubbleEvent(Object source, >>EventArgs args) +17 >> System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) >> +35 >> System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115 >> System.Web.UI.WebControls.Button.RaisePostBackEvent(String >> eventArgument) >>+163 >> >> System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String >>eventArgument) +7 >> System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler >>sourceControl, String eventArgument) +11 >> System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 >> System.Web.UI.Page.ProcessRequestMain(Boolean >>includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102 >> >> >> >> >> >>-------------------------------------------------------------------------------- >> >>Version Information: Microsoft .NET Framework Version:2.0.50727.42; >>ASP.NET >>Version:2.0.50727.42 >> |
|||||||||||||||||||||||