Problema con el SQL Server 2005

19/02/2006 - 21:10 por Alain Sanchez | Informe spam
Hola,
Estoy tratando de conectar a una base de datos que esta en
App_Data de la aplicación Web que realizo pero me sale este error :
Failed to genrate a user instance of SQL Server due to failure in
starting the process for the user instance. The connection will be
closed.
¿Por que me sale ese error ? Tengo que configurar algo extra...



Que tengo que hacer para vincular la configuración de membership de mi
aplicación Web con mi servidor de bases de datos SQL Server 2000, la
configuración actual que tengo es esta :

12<connectionStrings>
13 <add name="users" connectionString="Data Source=localhost;Initial
Catalog=aspnetdb;Integrated Security=true"
providerName="System.Data.SqlClient"/>
14</connectionStrings>

33<roleManager enabled="true" defaultProvider="SqlServer" />
...
35<membership defaultProvider="SqlServer" userIsOnlineTimeWindow="15">
<providers>
<clear />
<add
name="SqlServer"
type="System.Web.Security.SqlMembershipProvider"

ConnectionStringName="users"
applicationName="/"
enablePasswordRetrieval="false"
enablePasswordReset="true"
requiresQuestionAndAnswer="true"
requiresUniqueEmail="true"
passwordFormat="Hashed"
maxInvalidPasswordAttempts="5"
minRequiredPasswordLength="1"
minRequiredNonalphanumericCharacters="0"
/>
</providers>
53</membership>
...
y cuando intento usar WebSite -> ASP.Net Configuration -> Security ->
Create User me sale este este error :
An error was encountered. Please return to the previous page and try
again.

The following message may help in diagnosing the problem:
Default Role Provider could not be found. (~\Visual Studio
2005\Projects\CE Project\bpa_site\web.config line 33) at
System.Web.Administration.WebAdminPage.CallWebAdminHelperMethod(Boolean
isMembership, String methodName, Object[] parameters, Type[]
paramTypes) at ASP.security_users_adduser_aspx.PopulateCheckboxes() in
c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\ASP.NETWebAdminFiles\Security\Users\addUser.aspx:line
28 at ASP.security_users_adduser_aspx.Page_Load() in
c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\ASP.NETWebAdminFiles\Security\Users\addUser.aspx:line
22 at System.Web.Util.CalliHelper.ArglessFunctionCaller(IntPtr fp,
Object o) at
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender,
EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at
System.Web.UI.Control.LoadRecursive() at
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Saludos... ☺
Alain
 

Leer las respuestas

#1 Maxi [MVP]
20/02/2006 - 00:34 | Informe spam
Hola, proba primero conectarte via Mstudio y ver que pasa


Salu2
-
[MVP] SQL Server
Orador para Culminis Latam
www.sqlgurus.org

MSN:

"Alain Sanchez" escribió en el mensaje
news:
Hola,
Estoy tratando de conectar a una base de datos que esta en
App_Data de la aplicación Web que realizo pero me sale este error :
Failed to genrate a user instance of SQL Server due to failure in
starting the process for the user instance. The connection will be
closed.
¿Por que me sale ese error ? Tengo que configurar algo extra...



Que tengo que hacer para vincular la configuración de membership de mi
aplicación Web con mi servidor de bases de datos SQL Server 2000, la
configuración actual que tengo es esta :

12<connectionStrings>
13 <add name="users" connectionString="Data Source=localhost;Initial
Catalog=aspnetdb;Integrated Security=true"
providerName="System.Data.SqlClient"/>
14</connectionStrings>

33<roleManager enabled="true" defaultProvider="SqlServer" />
...
35<membership defaultProvider="SqlServer" userIsOnlineTimeWindow="15">
<providers>
<clear />
<add
name="SqlServer"
type="System.Web.Security.SqlMembershipProvider"

ConnectionStringName="users"
applicationName="/"
enablePasswordRetrieval="false"
enablePasswordReset="true"
requiresQuestionAndAnswer="true"
requiresUniqueEmail="true"
passwordFormat="Hashed"
maxInvalidPasswordAttempts="5"
minRequiredPasswordLength="1"
minRequiredNonalphanumericCharacters="0"
/>
</providers>
53</membership>
...
y cuando intento usar WebSite -> ASP.Net Configuration -> Security ->
Create User me sale este este error :
An error was encountered. Please return to the previous page and try
again.

The following message may help in diagnosing the problem:
Default Role Provider could not be found. (~\Visual Studio
2005\Projects\CE Project\bpa_site\web.config line 33) at
System.Web.Administration.WebAdminPage.CallWebAdminHelperMethod(Boolean
isMembership, String methodName, Object[] parameters, Type[]
paramTypes) at ASP.security_users_adduser_aspx.PopulateCheckboxes() in
c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\ASP.NETWebAdminFiles\Security\Users\addUser.aspx:line
28 at ASP.security_users_adduser_aspx.Page_Load() in
c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\ASP.NETWebAdminFiles\Security\Users\addUser.aspx:line
22 at System.Web.Util.CalliHelper.ArglessFunctionCaller(IntPtr fp,
Object o) at
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender,
EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at
System.Web.UI.Control.LoadRecursive() at
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Saludos... ?
Alain

Preguntas similares