Custom membership provider problem

[John]

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.e xe 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.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: 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.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion
exception, Boolean breakConnection ) +734979
System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning(Tds ParserStateObje ct
stateObj) +188
System.Data.Sql Client.TdsParse r.Connect(Boole an& useFailoverPart ner,
Boolean& failoverDemandD one, String host, String failoverPartner , String
protocol, SqlInternalConn ectionTds connHandler, Int64 timerExpire, Boolean
encrypt, Boolean trustServerCert , Boolean integratedSecur ity, SqlConnection
owningObject, Boolean aliasLookup) +820
System.Data.Sql Client.SqlInter nalConnectionTd s.OpenLoginEnli st(SqlConnectio n
owningObject, SqlConnectionSt ring connectionOptio ns, String newPassword,
Boolean redirectedUserI nstance) +628
System.Data.Sql Client.SqlInter nalConnectionTd s..ctor(DbConne ctionPoolIdenti ty
identity, SqlConnectionSt ring connectionOptio ns, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserI nstance)
+170
System.Data.Sql Client.SqlConne ctionFactory.Cr eateConnection( DbConnectionOpt ions
options, Object poolGroupProvid erInfo, DbConnectionPoo l pool, DbConnection
owningConnectio n) +130
System.Data.Pro viderBase.DbCon nectionFactory. CreatePooledCon nection(DbConne ction
owningConnectio n, DbConnectionPoo l pool, DbConnectionOpt ions options) +28
System.Data.Pro viderBase.DbCon nectionPool.Cre ateObject(DbCon nection
owningObject) +424
System.Data.Pro viderBase.DbCon nectionPool.Use rCreateRequest( DbConnection
owningObject) +66
System.Data.Pro viderBase.DbCon nectionPool.Get Connection(DbCo nnection
owningObject) +496
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.Secu rity.SqlMembers hipProvider.Cre ateUser(String username,
String password, String email, String passwordQuestio n, String
passwordAnswer, Boolean isApproved, Object providerUserKey ,
MembershipCreat eStatus& status) +3612
System.Web.UI.W ebControls.Crea teUserWizard.At temptCreateUser () +305
System.Web.UI.W ebControls.Crea teUserWizard.On NextButtonClick (WizardNavigati onEventArgs
e) +105
System.Web.UI.W ebControls.Wiza rd.OnBubbleEven t(Object source, EventArgs
e) +453
System.Web.UI.W ebControls.Crea teUserWizard.On BubbleEvent(Obj ect source,
EventArgs e) +149
System.Web.UI.W ebControls.Wiza rdChildTable.On BubbleEvent(Obj ect source,
EventArgs args) +17
System.Web.UI.C ontrol.RaiseBub bleEvent(Object source, EventArgs args) +35
System.Web.UI.W ebControls.Butt on.OnCommand(Co mmandEventArgs e) +115
System.Web.UI.W ebControls.Butt on.RaisePostBac kEvent(String eventArgument)
+163
System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP ostBackEvent(St ring
eventArgument) +7
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument) +11
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData) +33
System.Web.UI.P age.ProcessRequ estMain(Boolean
includeStagesBe foreAsyncPoint, Boolean includeStagesAf terAsyncPoint) +5102

--------------------------------------------------------------------------------

Version Information: Microsoft .NET Framework Version:2.0.507 27.42; ASP.NET
Version:2.0.507 27.42

[mablejune]

On Sat, 17 Dec 2005 03:04:17 -0000, "John" <Jo**@nospam.in fovis.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.e xe 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.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: 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.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion
exception, Boolean breakConnection ) +734979
System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning(Tds ParserStateObje ct
stateObj) +188
System.Data.Sql Client.TdsParse r.Connect(Boole an& useFailoverPart ner,
Boolean& failoverDemandD one, String host, String failoverPartner , String
protocol, SqlInternalConn ectionTds connHandler, Int64 timerExpire, Boolean
encrypt, Boolean trustServerCert , Boolean integratedSecur ity, SqlConnection
owningObject , Boolean aliasLookup) +820
System.Data.Sql Client.SqlInter nalConnectionTd s.OpenLoginEnli st(SqlConnectio n
owningObject , SqlConnectionSt ring connectionOptio ns, String newPassword,
Boolean redirectedUserI nstance) +628
System.Data.Sql Client.SqlInter nalConnectionTd s..ctor(DbConne ctionPoolIdenti ty
identity, SqlConnectionSt ring connectionOptio ns, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserI nstance)
+170
System.Data.Sql Client.SqlConne ctionFactory.Cr eateConnection( DbConnectionOpt ions
options, Object poolGroupProvid erInfo, DbConnectionPoo l pool, DbConnection
owningConnecti on) +130
System.Data.Pro viderBase.DbCon nectionFactory. CreatePooledCon nection(DbConne ction
owningConnecti on, DbConnectionPoo l pool, DbConnectionOpt ions options) +28
System.Data.Pro viderBase.DbCon nectionPool.Cre ateObject(DbCon nection
owningObject ) +424
System.Data.Pro viderBase.DbCon nectionPool.Use rCreateRequest( DbConnection
owningObject ) +66
System.Data.Pro viderBase.DbCon nectionPool.Get Connection(DbCo nnection
owningObject ) +496
System.Data.Pro viderBase.DbCon nectionFactory. GetConnection(D bConnection
owningConnecti on) +82
System.Data.Pro viderBase.DbCon nectionClosed.O penConnection(D bConnection
outerConnectio n, 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
connectionStri ng, Boolean revertImpersona tion) +197
System.Web.Secu rity.SqlMembers hipProvider.Cre ateUser(String username,
String password, String email, String passwordQuestio n, String
passwordAnswer , Boolean isApproved, Object providerUserKey ,
MembershipCrea teStatus& status) +3612
System.Web.UI.W ebControls.Crea teUserWizard.At temptCreateUser () +305
System.Web.UI.W ebControls.Crea teUserWizard.On NextButtonClick (WizardNavigati onEventArgs
e) +105
System.Web.UI.W ebControls.Wiza rd.OnBubbleEven t(Object source, EventArgs
e) +453
System.Web.UI.W ebControls.Crea teUserWizard.On BubbleEvent(Obj ect source,
EventArgs e) +149
System.Web.UI.W ebControls.Wiza rdChildTable.On BubbleEvent(Obj ect source,
EventArgs args) +17
System.Web.UI.C ontrol.RaiseBub bleEvent(Object source, EventArgs args) +35
System.Web.UI.W ebControls.Butt on.OnCommand(Co mmandEventArgs e) +115
System.Web.UI.W ebControls.Butt on.RaisePostBac kEvent(String eventArgument)
+163
System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP ostBackEvent(St ring
eventArgumen t) +7
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceContro l, String eventArgument) +11
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData) +33
System.Web.UI.P age.ProcessRequ estMain(Boolean
includeStagesB eforeAsyncPoint , Boolean includeStagesAf terAsyncPoint) +5102

--------------------------------------------------------------------------------

Version Information: Microsoft .NET Framework Version:2.0.507 27.42; ASP.NET
Version:2.0.50 727.42

[John]

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
<ma*******@otis mukinfus.com> wrote in message
news:98******** *************** *********@4ax.c om...

On Sat, 17 Dec 2005 03:04:17 -0000, "John" <Jo**@nospam.in fovis.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.e xe 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.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: 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.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion
exception, Boolean breakConnection ) +734979

System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning(Tds ParserStateObje ct
stateObj) +188
System.Data.Sql Client.TdsParse r.Connect(Boole an& useFailoverPart ner,
Boolean& failoverDemandD one, String host, String failoverPartner , String
protocol, SqlInternalConn ectionTds connHandler, Int64 timerExpire, Boolean
encrypt, Boolean trustServerCert , Boolean integratedSecur ity,
SqlConnecti on
owningObjec t, Boolean aliasLookup) +820

System.Data.Sql Client.SqlInter nalConnectionTd s.OpenLoginEnli st(SqlConnectio n
owningObjec t, SqlConnectionSt ring connectionOptio ns, String newPassword,
Boolean redirectedUserI nstance) +628

System.Data.Sql Client.SqlInter nalConnectionTd s..ctor(DbConne ctionPoolIdenti ty
identity, SqlConnectionSt ring connectionOptio ns, Object providerInfo,
String
newPassword , SqlConnection owningObject, Boolean redirectedUserI nstance)
+170

System.Data.Sql Client.SqlConne ctionFactory.Cr eateConnection( DbConnectionOpt ions
options, Object poolGroupProvid erInfo, DbConnectionPoo l pool, DbConnection
owningConnect ion) +130

System.Data.Pro viderBase.DbCon nectionFactory. CreatePooledCon nection(DbConne ction
owningConnect ion, DbConnectionPoo l pool, DbConnectionOpt ions options) +28
System.Data.Pro viderBase.DbCon nectionPool.Cre ateObject(DbCon nection
owningObjec t) +424

System.Data.Pro viderBase.DbCon nectionPool.Use rCreateRequest( DbConnection
owningObjec t) +66
System.Data.Pro viderBase.DbCon nectionPool.Get Connection(DbCo nnection
owningObjec t) +496
System.Data.Pro viderBase.DbCon nectionFactory. GetConnection(D bConnection
owningConnect ion) +82
System.Data.Pro viderBase.DbCon nectionClosed.O penConnection(D bConnection
outerConnecti on, 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
connectionStr ing, Boolean revertImpersona tion) +197
System.Web.Secu rity.SqlMembers hipProvider.Cre ateUser(String username,
String password, String email, String passwordQuestio n, String
passwordAnswe r, Boolean isApproved, Object providerUserKey ,
MembershipCre ateStatus& status) +3612
System.Web.UI.W ebControls.Crea teUserWizard.At temptCreateUser () +305

System.Web.UI.W ebControls.Crea teUserWizard.On NextButtonClick (WizardNavigati onEventArgs
e) +105
System.Web.UI.W ebControls.Wiza rd.OnBubbleEven t(Object source, EventArgs
e) +453
System.Web.UI.W ebControls.Crea teUserWizard.On BubbleEvent(Obj ect source,
EventArgs e) +149
System.Web.UI.W ebControls.Wiza rdChildTable.On BubbleEvent(Obj ect source,
EventArgs args) +17
System.Web.UI.C ontrol.RaiseBub bleEvent(Object source, EventArgs args)
+35
System.Web.UI.W ebControls.Butt on.OnCommand(Co mmandEventArgs e) +115
System.Web.UI.W ebControls.Butt on.RaisePostBac kEvent(String
eventArgument)
+163

System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP ostBackEvent(St ring
eventArgument ) +7
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl , String eventArgument) +11
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData) +33
System.Web.UI.P age.ProcessRequ estMain(Boolean
includeStages BeforeAsyncPoin t, Boolean includeStagesAf terAsyncPoint) +5102

--------------------------------------------------------------------------------

Version Information: Microsoft .NET Framework Version:2.0.507 27.42;
ASP.NET
Version:2.0.5 0727.42